List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 20 2001 5:59pm
Subject:Re: Semi colons in text fields in update statement
View as plain text  
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='&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

Semicolons in strings aren't special.  You may have some other problem.
You say you get an error message.  What is it?

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