At 2:00 PM -0400 9/20/01, Will French wrote:
>There probably is a better way but the following should work:
>"UPDATE tblCompany SET CoName=CONCAT('"', CHAR(59), 'tester', CHAR(59),
>'"', CHAR(59)) WHERE CoID=109"
>Like you, I believe there probably is an escape sequence for the semi-colon
>but I'll be damned if I can find it documented. Until someone else
>enlightens us both, hopefully the above solution will see you through.
There is no need for such an escape sequence because semicolons
in strings are not special. Maybe it's an ADO bug.
>> -----Original Message-----
>> From: johnlucas-Arluna [mailto:johnlucas@stripped]
>> Sent: Thursday, September 20, 2001 1:45 PM
>> To: mysql@stripped
>> Subject: Semi colons in text fields in update statement
>> 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
Paul DuBois, paul@stripped