Hello
I'm trying to do the following:
"Update tblCompany SET CoName='"tester"' WHERE CoID=109"
But getting an error message
I tried the escape character "\" like
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109"
but get the same error
This happens whether I use ADODB in VB or if I try executing the query
through DBTools 1.0.9
Can anybody tell me how I can escape the semi-colon please?
Many thanks for any help
John
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
