> "Update tblCompany SET CoName='"tester"' WHERE CoID=109"
It's not the query string. I just submitted this query using urSQL
(uses ODBC) and it worked just fine (assuming CoName is a varchar(32)).
I'm also able to successfully run this query and similar queries via ADO
from a Delphi application without a problem. This doesn't eliminate ADO,
but it does raise doubts that ADO is the problem...
You might want to submit your CREATE TABLE statement and (as Paul
suggested) the exact error message you are experiencing.
On Thu, 20 Sep 2001, 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
>
---------------------------------------------------------------------
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
