Home » RDBMS Server » Networking and Gateways » problem with the ' in SQL statement
problem with the ' in SQL statement [message #367699] Thu, 18 November 1999 17:58 Go to next message
DOUBLE D
Messages: 1
Registered: November 1999
Junior Member
error:

MicrosoftODBC Microsoft Access 97 Driver
Syntax error (missing operator) in query expression

'NaamCategorie = 'PC desktop Camera 's''.

cause:

test = PC desktop Camera 's
(the problem is the -> 's ) what can i do????

statement:

<% CATEGORIEID SET CATEGORIEŽN RSTEMP3='link.execute("select' ) % NAAMCATEGORIE='"& test &"' FROM WHERE>

What can i do about this????
Re: problem with the ' in SQL statement [message #367712 is a reply to message #367699] Mon, 29 November 1999 04:55 Go to previous message
Daniel Drees
Messages: 2
Registered: August 1999
Junior Member
Did you try it this way?

test = 'PC desktop Camera ''s'
Previous Topic: ORA-12224 : TNS no listener
Next Topic: ODBC driver use with MS Excel.
Goto Forum:
  


Current Time: Tue Feb 27 00:19:17 CST 2024