Reuse parameters in variables

Hi, please can someone help me with this as I have been searching the forums for over an hour.

There is some indication that the code Dreamweaver creates does not allow more than one recordset to use the same variable parameter, ie a URL parameter in both recordset queries.

Can someone please help with how I can manually adjust the code so that it works?

This is what I have so far for one recordset, which bit do I change?

quote:

---

<%
Dim RSsepcsubdetail
Dim RSsepcsubdetail_cmd
Dim RSsepcsubdetail_numRows

Set RSsepcsubdetail_cmd = Server.CreateObject ("ADODB.Command")
RSsepcsubdetail_cmd.ActiveConnection = MM_conn_vb_pureinfo_STRING
RSsepcsubdetail_cmd.CommandText = "SELECT * FROM specs_detail WHERE prod_code = ?"
RSsepcsubdetail_cmd.Prepared = true
RSsepcsubdetail_cmd.Parameters.Append RSsepcsubdetail_cmd.CreateParameter("param1", 200, 1, 255, RSsepcsubdetail__MMColParam2) ' adVarChar

Set RSsepcsubdetail = RSsepcsubdetail_cmd.Execute
RSsepcsubdetail_numRows = 0
%>

---

As you can see, this recordset only has one parameter variable, but my next recordset, on the same page, has the same recordset variable.