OraFAQ Forum: Networking and Gateways » problem with the ' in SQL statement

Home » RDBMS Server » Networking and Gateways » problem with the ' in SQL statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem with the ' in SQL statement [message #367699]

Thu, 18 November 1999 17:58

DOUBLE D
Messages: 1
Registered: November 1999

Junior Member

error:

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 02:29:25 CDT 2025