Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 03, 2012 01:05 AM by Prashant Kumar
Nov 03, 2012 12:33 AM|LINK
I have fought with this all day!
I need to select records by date, this is my present script.
WeekDate = Request("txtRqDate")
rsClndr.Open "SELECT * FROM UvClndr WHERE UvDate = #" & WeekDate & "#, cnnct, 3, 3
I do not know how many different syntax's I have tried, but I have not hit the right one.
Thanks in advance for any assistance
Nov 03, 2012 01:05 AM|LINK
I guess you are in the wrong forum - your question is about ADO not ASP.Net/ADO.Net
As to your question, you should be using a parameterized query.
Some references http://support.microsoft.com/kb/200190