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:
I then did a search for email@example.com then the search result will display the 3 email address
If I then did a search for firstname.lastname@example.org then the search result will display email@example.com AND firstname.lastname@example.org
If I then did a search for email@example.com then the search result will display firstname.lastname@example.org AND email@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?