I am searching my database using the Like keyword. I have implemented asp paging to display the results over several pages. I noticed that when I click on next page, I lose my SQL Statement. I solved this by passing along the SQL Statement, e.g. filename.asp?page=2&SQLStament.
My SQL Statment works, however it doesn't like the % in the LIKE keyword when move from page 1. This is my SQL Statement:
rSqlText= SELECT * FROM qryTaskSpecficWorks WHERE UCase(Author) Like '%GRAFF%'
When page 2 is displayed my SQL Statement becomes:
rSqlText= SELECT * FROM qryTaskSpecficWorks WHERE UCase(Author) Like '_AFFð/LM/W3SVC/1/ROOT
I believe this happens because it doesn't know the difference between a space in the address bar (%20) and the % in the Like Clause.
Any assistance would be appreciated.
RCORR