If you would like to have a recordset for each item in the cart then you would have this loop occur for the recordset. This will let you have recordsets for each item in the cart. This is not a simple setup, it is custom and will require some additional custom coding to implement.
If you have a recordset that you are filtering for a particular item you can store that records values in a session variable and reference it on any other page in the site. If you want to have the recordset run for all of the items in the cart you will need to loop over your recordset code so that the recordset occurs once for each item. You will need to have unique session variables that hold the values, then you can reference them on your cart page or any other page in the site.