While Not rsResults. I wrote this code while writing this article. It has not been fully tested. In theory it should work. More important than running source code are the ideas behind the code.
Source code is a mere transformation of ideas into something a computer can understand.
If you truly understand the ideas, the code should write itself. Hopefully you can understand what this code is doing. This file, Search.asp , will be called the first time a search is executed and each time the user wants to view the next N records. The current ID is an important value, it tells this page which records we've already seen. Next we parse out our Search String into a string variable called tmpSQL .