|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
"Where" |
|
From: |
Neil |
|
Date: |
3/29/2000 1:18:57 PM |
|
IP: |
204.50.177.113 |
Hi,
Any one know if this can be done??
DayNo=request.querystring("DateNo")
if DayNo=1 then
DayNo=Day1
end if
if DayNO=2 then
DayNo=Day2
end if
connecting to DB stuff.....
set objRecordset= server.CreateObject("ADODB.Recordset")
MySql = "Select * from DeliBar Where (" & DayNo & ")
objRecordset.Open MySql, DB_Connectionstring
I know I can use the..
Where whatfield = " & DayNo & " "
But I want to get rid of the whatfield and have the "where dynamic to whats passed throught the QueryString.
|
Follow Up - Re: Can be done - Shailesh Lolam 4/8/2000 8:45:03 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
