RE: Semi colons in text fields in update statement

[Will French]

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.

> -----Original Message-----
> From: johnlucas-Arluna [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 1:45 PM
> To: [EMAIL PROTECTED]
> 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
>
>
> ---------------------------------------------------------------------
> 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
>
>


---------------------------------------------------------------------
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