Hey,
In standard ANSI SQL, you escape the quote by ... the quote symbol.
Your select statement should therefore say :
SELECT * FROM Players WHERE LName LIKE '%D''Silva%'
Cheers,
Henri
[EMAIL PROTECTED] on 09/19/2002 10:38:09 AM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
cc:
Subject: RE: How to query for an apostrophe
Hi,
The following will probably work for you:
SELECT * FROM Players WHERE LName LIKE '%D\'Silva%' ESCAPE '\'
I haven't tested this with Access, but I do a similar thing with MS SQL
Server which works OK.
Regards,
Rob
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 4:56 AM
To: [EMAIL PROTECTED]
Subject: How to query for an apostrophe
Hiya. How can I search for the following?:
D'Silva
If I try to search for it, with the following query string:
SELECT * FROM Players WHERE LName LIKE `%D'Silva%`
I get the following error:
Died while executing:[Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1. (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at
c:\inetpub\wwwroot\EBA\cgi-bin\player_search.pl line 709.
Is there a way to escape the apostrophe?
Thanks for your help!
Nick Hoffman
[EMAIL PROTECTED]
This message is intended only for the use of the person(s) ("The intended
Recipient(s)") to whom it is addressed. It may contain information which
is privileged and confidential within the meaning of applicable law. If
you are not the intended recipient, please contact the sender as soon as
possible. The views expressed in this communication are not necessarily
those held by LYNX Express Limited.
