Hello all, how are you?

New error to contend with, hope you can help.

Just to give you a quick heads up and say im new to this (ASP, stored procedures etc), so sorry for lack of terminology that may crop up.

I'm trying to return a selection of images from a database, by using stored procedures to return the image(s) to an ASP page. However when try to run the file on my localhost, i get the following error:

ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/admin/stores/index.asp, line 240

line 240:
Quote:
<input type="hidden" id="floorID" name="floorID" value="<%=oRS("floorplansID")%>"/>


I've executed the Stored procedure and its working fine. The connection to the database is ok, as all other pages seem to be working fine. I have also checked all the names and variables, and al the names seem to be the same.

Any ideas as to why this may be happening would be great.

<%=oRS("floorplansID")%> would be looking for a field in a recordset to display, NOT executing a stored procedure


http://www.asp101.com/articles/wrox/asp30/26100903.asp

Hi Chrishirst, thank you for the reply.

Also, thank you for the link. Just to say I am new to the world of ASP coding and strored Procedures, im carrying on some work set by my previous manager.

I have worked with an example set by my former manager, following it as he had set (at least i thought). The stored procedure(s) are held / executed on SQL server, but this error is killing me - any extra infor would be great.

Kind regards
MG

If you sql query looks something like following than make sure the Table you are calling in query has "floorplansID" column

SELECT * FROM [TABLENAME]

If your sql query looks something like following than make sure you to mentioned "floorplansID" field in sql qeury.

SELECT FIELD1, FIELD2 FROM [TABLENAME]