ADODB.Recordset (0x800A0CC1) Error

[blondebier]

Any ideas what the following error means?

Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/addprod.asp, line 54

This is line 54 of addprod.asp:

set rscatlist=db.execute("select name,productid from products where catcode=" & rsprod("catcode&quot & " order by name&quot

I include a db connection file db.asp:

<!-- #include file=&quot;adovbs.inc&quot; -->
<%

dim db
dim strConn

strConn = &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; & _
&quot;Data Source=C:\inetpub\

http://wwwroot\data.mdb;&quot;

& _
&quot;Persist Security Info=False&quot;

Set db = Server.CreateObject(&quot;ADODB.Connection&quot
db.open strConn
%>

Any help would be greatly appreciated.

 

[JamesLean]

I would say the error is referring to this part of that line:

rsprod("catcode")

How are you creating the rsprod recordset? Can you give us that part of your code?

--James

 

[blondebier]

This is the rsprod recordset:

set rsprod=db.execute(&quot;SELECT * FROM products INNER JOIN categories ON products.catcode = categories.catcode WHERE productid = &quot; & productid)

Thanks.

 

[JamesLean]

You might need to refer to the column like this as there is more than one column called catcode in the resultset:

rsprod("products.catcode")

As a general rule, specifying the columns you want to return is usually preferred to

SELECT *

for a number of reasons, one of which is nicely illustrated here! ;-)

--James