[thelist] SQL Rowcount Problem (solved)

[Seth Bienek]

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