What is the problem?
Usually you can do it either with:
rst["SomeField"] = intValue
or cnn.Execute("UPDATE SomeTable SET SomeField = " & intValue)
ADOxtra - ADO databasing over LAN, over Internet for Director and MUS.
VbScriptXtra - Full control over MS Word, Excel, IE etc., ADO, ADOX, ADOMD,
DAO right from Lingo.
"janosch" <webforumsusermacromedia.com> wrote in message
How can I insert an integer variable in an sql-string? I know how to do it
with string-variables ('"&text&"") which works fine, but I don't get it
working with integer variables. I tried '+number+' and all kinds of
variations, but nothing works. I keep getting the error that tells me that
there the types are not the same.
Code = 80040e07
Code meaning = IDispatch error #3079
does anybody know what I have to do?