Hi,
I am getting an invalid token error from revExecuteSQL, when I look
at the data being inserted, it contains a ":" character following by
a number (a date field in the form DD:MM:YY. How do I insert this data?
Here is the code:
put "INSERT INTO " & theTableName & " (" & myTempKeyList & ") " & \
" VALUES (" & myValueList & ") " into mySQLCode
revExecuteSQL theDatabaseID,mySQLCode
put the result into myResult
if myResult <> empty then
if myResult is not an integer then
answer error "Error in UtilDBInsertRecord, revExecuteSQL:"
&& myResult
breakpoint
end if
end if
Thanks a lot
All the Best
Dave
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
