Re: passing sql from asp

Article View: comp.databases.ms-access

Article #178

Back to comp.databases.ms-access Previous Next

#178

From: Thomas J
Date: Fri, 17 Dec 1999 00:00

45 lines
2373 bytes

Hi,
you must take '%rest%'

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




Eyal Maaravi schrieb in Nachricht
<83bleq$2gh$1@news.netvision.net.il>...
>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: <385a7c82.0@news.ivm.net>

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

References: <83bleq$2gh$1@news.netvision.net.il>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff435,f76d89cd0bf069f
X-Google-Attributes: gidff435,public
X-Google-Thread: ff0ac,f76d89cd0bf069f
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 11633f,f76d89cd0bf069f
X-Google-Attributes: gid11633f,public
X-Google-Thread: 114664,f76d89cd0bf069f
X-Google-Attributes: gid114664,public
X-Google-Thread: 115df1,f76d89cd0bf069f
X-Google-Attributes: gid115df1,public
X-Google-Thread: 10f6af,f76d89cd0bf069f
X-Google-Attributes: gid10f6af,public
X-Google-Thread: 162feb,f76d89cd0bf069f
X-Google-Attributes: gid162feb,public
X-Google-Thread: fdea5,f76d89cd0bf069f
X-Google-Attributes: gidfdea5,public
From: "Thomas J" <thomas.juenemann@metronet.de>
Subject: Re: passing sql from asp
Date: 1999/12/17
Message-ID: <385a7c82.0@news.ivm.net>
X-Deja-AN: 562032279
X-NNTP-Posting-Date: 17 Dec 1999 19:10:10 MET
X-NNTP-Posting-Host: 62.52.131.93
References: <83bleq$2gh$1@news.netvision.net.il>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Admin-Comment: If present, X-NNTP-Posting-... are valid
X-Complaints-To: usenet@ivm.net
X-Trace: 17 Dec 1999 19:10:10 MEST, mwnews.dnsg.net
Organization: debitel.net - der Onlinedienst
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

Reply to Parent Message