Incomplete data

[pbms]

First page displays a grid with about 1400 records. My users can drill down (using Magic Cell) to 2nd page with approximately 7 different select statements each displayed in their own grid.
Here is where my problem starts. On the first few passes all is well on both pages. Then the second page will only give me a few of the rows for each grid. It is very intermittent, but once it starts I can never get the whole set again. And I can drill down on the a record that I know has more information, yets still it only give me half of the records.
Help!

[Mark]

This is just a guess because I don't have your source code, but if you have any variables in your WHERE clause, you MUST do a dbReset whenever those variables change. This forces ASP-db to re-count the records using the new SQL.

Good examples of this at:
http://www.aspdbtest.com/examples/ViewPro/
See example 5a.

I hope that helps.

[pbms]

That took care of it. I have used the reset before, and forgot that I have a where clause in this select statement.
It is an annoying way to fix it, since most of my queries have where clauses.

Thanks for your help.