>I'm dynamically generating a form page with data retrieved from a SQL Server and populating the page with checkboxes and textboxes for input updates.
>
>The recordset returned will be small, usually between 10-30 records but because it involves a 3-table join, it's slower than it should be.
>
>Now to my question: Is there a way to keep the recordset around so that I don't have to requery the same recordset? One way I'm told is to put the data in an array that's stored in a session variable and then loop through it to determine any changes. This would work but I hate keeping "things" danggling around in the session object.
>
>Any suggestions? TIA.

Are you using a stored proc. to get the recordset.