Re: ADO exception with character combination inside string...

Enclose TNC:\CHARLIE in single quotes. Any database that follows the
SQL standard will assume that a string enclosed in double quotes is a
quoted identifier (table name, field name, etc.) not a string literal.

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Syntax error (missing operator) in query expression
    ... > and how to use single quotes and double quotes in ASP? ... expression to "scrub" the search term prior to constructing the SQL ... query depending on your database environment) instead of dynamically ... constructing the SQL statement. ...
    (microsoft.public.inetserver.asp.general)
  • Re: SQL Injection
    ... Make sure you always escape single quotes and other magic characters when ... you enter data into your database. ...
    (borland.public.delphi.non-technical)
  • Re: What Did I Miss Here?
    ... Is the Use Quoted Identifiers option checked in your database property sheet ... under the Options tab? ... > In the database it is being stored as two single quotes. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Need a Strategy to store the Single Quotes in the Database
    ... >> Database where if i try to Store the String value with Single Quotes ... >> then it is throwing the error as SQL String Truncated. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Troubles with database searching
    ... form I must include the single quotes. ... This is a suprise to me as I did not ... > of addresses that i want to be able to search throught via my site. ... > 2) at the last step in the database results wizard made sure that the "Add ...
    (microsoft.public.frontpage.programming)