PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED]
Subject: RE: Semi colons in text fields in update statement
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)
> "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 applicat
perly account for its being embeded in a literal string.
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 20, 2001 2:15 PM
> To: [EMAIL PROTECTED]; johnlucas-Arluna; [EMAIL PROTECTED]
> Subject: RE: Semi colons in text fields in update s
>
> There is no need for such an escape sequence because semicolons
> in strings are not special. Maybe it's an ADO bug.
>
Paul et al - I think his problem is with quotes, not semicolons. The line
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109" is what
leads me to believe this.
Tr
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
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
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 ge
