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

Report message to a moderator

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'

Report message to a moderator

Previous Topic: ORA-12224 : TNS no listener
Next Topic: ODBC driver use with MS Excel.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 23:03:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.