List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 20 2001 6:15pm
Subject:RE: Semi colons in text fields in update statement
View as plain text  
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('&quot', CHAR(59), 'tester', CHAR(59),
>'&quot', 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
>>
>>
>>  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='&quot\;tester&quot\;' 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
Thread
Semi colons in text fields in update statementjohnlucas-Arluna20 Sep
  • Re: Semi colons in text fields in update statementPaul DuBois20 Sep
  • RE: Semi colons in text fields in update statementWill French20 Sep
    • RE: Semi colons in text fields in update statementPaul DuBois20 Sep
      • RE: Semi colons in text fields in update statementJay Fesco20 Sep
      • RE: Semi colons in text fields in update statementWill French20 Sep
      • RE: Semi colons in text fields in update statementjohnlucas-Arluna20 Sep
  • Re: Semi colons in text fields in update statementj.urban20 Sep