sql query refreshing in a table

[NTSGuru]

I have an asp that I am working in. I created a recordset object and am able to load the initial table with the info from SQL very nicely. What I cannot seem to do is change the SELECT for the SQL statement and reload the table in the page. Does anyone have any ideas how to do this? I am trying not to use the DTC grid because it seems too slow to handle the size of the recordset that I am using.

TIA
Fred