I have another post on this topic but wanted to add this here too. Because of the failures I had with paging through results in a tableset, I decided to re-write the page using dreamweaver MX, and I got the same failures as when I did it by non dreamweaver. You can get the first 10 records and then when you go to 'Next' there are no results, albeit that they are there. I have set up some javascript boxes that show the values going in on the first pass but when you go to 'Next' there are no values. Now the sql results are dependant on the values from the form, which do not seem to be held in any session variables. So any ideas, go to this url to check out what I mean, fill in some details, (Not the Waterfront Otion Please) and then after grabbing the first page, click 'Next' at the bottom of the page.
http://www.homestarrg.com/buyers/mls_full_search_dev2.php