help me to write replace function for date
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
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.
u r answer helped me to retrive that row