Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Incorrect search results if searching by date range and any other criteria

View all replies to this thread

Incorrect search results if searching by date range and any other criteria

Thread began 7/01/2011 5:31 am by YellowCircleWeb | Last modified 7/01/2011 12:18 pm by YellowCircleWeb | 1848 views | 5 replies

7/01/2011 5:31 amYellowCircleWeb

Incorrect search results if searching by date range and any other criteria

Hi,

I've created a search page that searches records by various criteria and is mostly working fine. However, one of the search criteria is a date range (I'm using the WA Datepicker control for these fields).

If I search for records between 2 specific dates I get the correct results returned. If I search for records using search criteria and not entering any dates I get correct results. If I search for records using a date range and then any other criteria I get all the records returned, not just the correct ones. I've been trying to solve this for all day and so far cannot get it working. It's like the page is ignoring the unique value I also tell it to check for (ACCOUNT_REF) when I use dates and other criteria.

I've attached the two files involved and wonder if anyone can point me in the right direction as to why I'm getting incorrect results.

Attached Files

order-search-results.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.