Search filter doesn't work with 3 entries in database!

Hi, if you could look at the code attached. I have setup a search box on the page to filter by email address. Now this code is duplicated exactly the same on my other pages (changing recordsets and session names relevant to that page) and those other pages appear to work how they should (the other pages have at 12 and 233 results and the search result on email address updates the page to the relevant email address - usually 1 result).

However...on the page attached...currently the recordset displays 3 entries. and if i were to search by email address for this page..it doesnt display just the 1 entry...

if for example my 3 entries on the page (before search) were:

email1@example.com
email2@example.com
email3@example.com

I then did a search for email1@example.com then the search result will display the 3 email address

If I then did a search for email2@example.com then the search result will display email2@example.com AND email3@example.com

If I then did a search for email@example.com then the search result will display email2@example.com AND email3@example.com

So it doesnt make sense to me with the above result tests for this page that only contains 3 entries...however the same code works for my other pages with more then 12 results.

Any thoughts on how I have set up the code on the page?

Chris

you have an existing where clause on the recordset:
WHERE OrderProcess = 'NEW' OR OrderProcess = 'Failure' OR OrderProcess = 'Cancelled'

use parenthesis around those clauses:
WHERE (OrderProcess = 'NEW' OR OrderProcess = 'Failure' OR OrderProcess = 'Cancelled')

the existing o clauses are causing ambiguous search term by adding parenthesis, the existing or clauses are processed first, then the email address and clause is performed on that result.

You Sir are amazing! Thank you that solved the issue, greatly appreciated Jason :)

you're welcome.