At 6:44 PM +0100 9/20/01, johnlucas-Arluna wrote:
>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
Semicolons in strings aren't special. You may have some other problem.
You say you get an error message. What is it?
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
