help me to write replace function for date

[sonasiva]

dear all
iam new for ASP
i need to retrive record form database for a particular DATE and particular name
i have to pass date and name thro "form" then i have to display that particular record


please anybody tell me the query how to proceed

thanks in advance
sona..............

[SSJ]

Use Following Query to retrive the record:
SQL="SELECT dDate FROM tblDate WHERE dDate=#" & Date() & "# AND name=' " &name&" ' "

You can use the hidden fields of form to pass these values.

-SSJ

[sonasiva]

u r answer helped me to retrive that row

thanks