Help for Select SQL Query with date filter
hi,
i want to execute the follwing query
dim datetemp
datetemp=trim(request.form("datefield"))
dim rs
set rs=CreateObject("ADODB.RecordSet")
rs.open "Select * from News where newsDate="&datetemp
I also try with
rs.open "Select * from News where newsDate=#"&format(datetemp,mm/dd/yyyy)&"#",GetConnection,2,2
but this give the Runtime Error-"OverFlow"
suggest me the solution for how to fire the select query withthe date filter on .asp page
|