RE: Semi colons in text fields in update statement

2001-09-20 Thread johnlucas-Arluna
lution 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:[EMAIL PROTECTED]] >> Sent: Thursday, September 20, 2001 1:45

Re: Semi colons in text fields in update statement

2001-09-20 Thread j.urban
> "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

RE: Semi colons in text fields in update statement

2001-09-20 Thread Will French
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

RE: Semi colons in text fields in update statement

2001-09-20 Thread Jay Fesco
> > 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

RE: Semi colons in text fields in update statement

2001-09-20 Thread Paul DuBois
not special. Maybe it's an ADO bug. > >> -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

RE: Semi colons in text fields in update statement

2001-09-20 Thread Will French
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 P

Re: Semi colons in text fields in update statement

2001-09-20 Thread Paul DuBois
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

Semi colons in text fields in update statement

2001-09-20 Thread johnlucas-Arluna
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 get the same error This happens whether I use ADODB in VB or if