[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,
Seth
More information about the thelist
mailing list