I have a page that is primarily designed to search the database for all entries within the entered state.
I'd like to open the page with no results being returned in the results form. Currently when the page is loaded it returns all the records in the db.
Here is the select statement:
"SELECT * FROM National WHERE (State like '%::SearchValue::%') ORDER BY State ASC"