The recordset code will be created in the head of the page before the doc type tag.
Since you want to create a unique record set for each product that is being displayed, the recordset code will need to be moved so that it is inside the repeat region.
if you need more specifics than that, please send a copy of your page.