2. ASPRunnerPro General questions
  3. Searching by date...
This topic is locked

Searching by date...

 		9/20/2005 3:26:07 PM
ASPRunnerPro General questions
author

Problem: when I search for a specific date on the list page, I get no records, and when I do the same search in the advanced search page, I get all of the records returned, regardless of date.
Are there some issues when formatting date values? Any ideas appreciated. Thanks...
Sergey Kornilov admin 9/20/2005

When you search for any specific date make sure you choose Equals as an option.
For example you can go to ASPRunnerPro live demo (Orders page):

http://www.xlinesoft.com/asprunnerpro/live...Orders_list.asp
If I search for any fields equals 7/19/1996 I get two orders.

If I enter date as 1996-7-19 (yyyy-mm-dd) I get correct result as well.
If advanced search returns all records this means something goes wrong.

Open include/commonfunctions.asp file in any text editor and change vDbeug variable from falseto true.
Run advanced search again and post generated SQL statement here.
501260 9/22/2005

Thanks. I think that did it!
500320 9/25/2005

I too have problems with date search.
I changed the vDebug in the commonfunctions.asp to true and then I see the actual query on the list page.



EXAMPLE

select [ordID], [ordSessionID], [ordName], [ordAddress], [ordCity], [ordState], [ordZip], [ordCountry], ETC., ETC.
Am I doing something wrong? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=6117&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' />
Sergey Kornilov admin 9/25/2005

Techno,
what exactly is the problem with date search and what is the full SQL query?
C
 		chriscps 7/13/2006

Posted in Error