At 6:44 PM +0100 9/20/01, johnlucas-Arluna wrote:
Hello
I'm trying to do the following:
Update tblCompany SET CoName='quot;testerquot;' WHERE CoID=109
But getting an error message
I tried the escape character \ like
Update tblCompany SET CoName='quot\;testerquot\;' WHERE CoID=109
but get
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.
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
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='quot\;testerquot\;' WHERE CoID=109 is what
leads me to believe this.
-
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 statement
At 2:00 PM -0400 9/20/01, Will French wrote:
There probably is a better way
Update tblCompany SET CoName='quot;testerquot;' 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
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('quot', CHAR(59), 'tester', CHAR(59),
'quot', CHAR(59)) WHERE CoID=109
Like you, I believe there probably