Stored Procedure cursor

I have an ASP page that reads a database query through a stored procedure to display a list of products with page navigation (max 6 products per page).  Alongside each product I also have a BUY NOW button.  Products are displaying well but whenever I hit the BUY NOW button, it falls over.

I believe the problem lies with the ForwardOnly default cursor, which is great for the sequential display of products.  The BUY NOW function attempts a .MoveFirst() and this is where it is falling over.

Do I need a dynamic cursor in my stored procedure?  If so, how do I do this?  Here's the current call from ASP....

Dim rsFav
Dim rsFav_cmd
Dim rsFav_numRows
Set rsFav_cmd = Server.CreateObject ("ADODB.Command")
rsFav_cmd.ActiveConnection = MM_ConnDBA_STRING
rsFav_cmd.CommandText = "EXECUTE GetSubCatProductList ?"
rsFav_cmd.Prepared = true
rsFav_cmd.Parameters.Append rsFav_cmd.CreateParameter("param1", 200, 1, 255, rsFav__MMColParam) ' adVarChar
Set rsFav = rsFav_cmd.Execute
rsFav_numRows = 6

Any help is much appreciated....Start Free Trial