[thelist] SQL Rowcount Problem (solved)

Seth Bienek seth at sethbienek.com
Mon Jun 24 09:10:01 CDT 2002

Hi All,

Thanks for all the great insight on this issue.  I should have mentioned
that the root of my problem is that I was hoping to avoid doing multiple
queries (one solely for recordcount, and one with the punctuated
recordset for the actual query results).

What I decided to do was to go ahead and break it into two queries, and
cache the rowcount query, having it update any time a row is added to
the main table in the query.

Thanks again,


More information about the thelist mailing list