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

If the column in the database is a datetime column you will need to put single quotes around the date:

rs.open "SELECT * from News WHERE newsDate='"&datetemp&"';"

You'll probably also want to validate that you're sending an actual date to the query.

You can also do this to check the query in Query Analyzer but I really don't know what database your using.

SQL = "SELECT * from News WHERE newsDate='"&datetemp&"';"
Response.Write(SQL)
Response.End

I don't use the open method very often so you're on your own there.

Richard