|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
