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