Hi everyone,
I am using an odbc connection to an Access db where a number of records are returned. I have the results paginated so that 15 results appear per page.
My problem is that I have a search functionality so that the user can enter a keyword and the field they want to search. I capture the keywords & fields in a session variable so that when the next page is selected the appropriate search results are returned.
However, when the user exits the page then returns later their earlier search options are remembered rather than the page refreshing to a 'search all' default.
Is there a way of killing the session for the search variables when the user exits the page, but retaining the session while they are paginating through results?
Any guidance would be appreciated! 🙂