passing sql from asp

Article View: comp.databases.ms-access

Article #176

Back to comp.databases.ms-access Previous Next

#176

From: Eyal Maaravi
Date: Thu, 16 Dec 1999 00:00

25 lines
2050 bytes

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

Technical Details

Message-ID: <83bleq$2gh$1@news.netvision.net.il>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115df1,f76d89cd0bf069f,start
X-Google-Attributes: gid115df1,public
X-Google-Thread: ff435,f76d89cd0bf069f,start
X-Google-Attributes: gidff435,public
X-Google-Thread: 114664,f76d89cd0bf069f,start
X-Google-Attributes: gid114664,public
X-Google-Thread: 162feb,f76d89cd0bf069f,start
X-Google-Attributes: gid162feb,public
X-Google-Thread: 10f6af,f76d89cd0bf069f,start
X-Google-Attributes: gid10f6af,public
X-Google-Thread: ff0ac,f76d89cd0bf069f,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11633f,f76d89cd0bf069f,start
X-Google-Attributes: gid11633f,public
X-Google-Thread: fdea5,f76d89cd0bf069f,start
X-Google-Attributes: gidfdea5,public
From: "Eyal Maaravi" <netc1@netvision.net.il>
Subject: passing sql from asp
Date: 1999/12/16
Message-ID: <83bleq$2gh$1@news.netvision.net.il>
X-Deja-AN: 561694727
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@netvision.net.il
X-Trace: news.netvision.net.il 945379610 2577 62.0.169.29 (16 Dec 1999 21:26:50 GMT)
Organization: NetVision Israel 
X-MSMail-Priority: Normal
NNTP-Posting-Date: 16 Dec 1999 21:26:50 GMT
Newsgroups: comp.databases.ms-access,cz.comp.microsoft.asp,dk.edb.internet.webdesign.asp,microsoft.public.de.inetserver.iis.asp,microsoft.public.iis4.beta.database,microsoft.public.sqlserver.odbc,microsoft.public.vb.database.odbc,microsoft.public.win98.pws_4