passing sql from asp

[Eyal Maaravi]

hi

i want to create a recordset from an ASP page using an SQL string;

the SQL is:

SELECT * FROM Business_qry WHERE name Like '*rest*'

i opened the recordset in the following way:

set rsCoupons = CreateObject("ADODB.Recordset")
rsCoupons.Open "SELECT * FROM Business_qry WHERE name Like '*rest*'", _
"DATABASE=myDB;UID=;PWD=;DSN=myDB"

that doesn't work, and the problem is with the operator like and with the
asterisk.

i succeeded executing the exact same SQL in Access, in it worked fine.

please help if you know the answer.

thanks in advance

eyal maaravi

[Peter van Kampen]

Eyal,

* = % in SQL-92

Hth,

PeterK
--

Access FAQ : www.mvps.org/access
To Search the archives of this NG : http://people.a2000.nl/kampen/access/

Eyal Maaravi <ne...@netvision.net.il> wrote in message
news:83bleq$2gh$1...@news.netvision.net.il...

[Thomas J]

Hi,
you must take '%rest%'

mfg
Thomas J.
***********************************************
Homepage: http://www.heckerothconsult.com/Thomas
E-Mail: thomas.j...@metronet.de

Eyal Maaravi schrieb in Nachricht
<83bleq$2gh$1...@news.netvision.net.il>...