[algorithm]

Hi there . i am getting this error message

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/desc.asp, line 177

Line 177
if(not isNull(rs("photoid").Value)) then

Set rs1 = Server.CreateObject("ADODB.Recordset")

rs1.Open "select [FileData],[ContentType], from upload_table where ImgId = & _
rs("photoid"), cn, 2, 4

If Not rs1.EOF Then
Response.ContentType = rs1("ContentType")
Response.BinaryWrite rs1("FileData")
End If

Please tell me how can i remoove this error message

Thanks in advance.

[omniman]

It's a problem with the column name. Unless you specify otherwise in your query, it will return the column name as the field. Seems to be a problem with 'photoid'.

[algorithm]

thanks man .

[algorithm]

Hi omniman
Actually i am just copy pasing the code with little modification.. what can be the possible solution

[omniman]

As I said before, it looks to be a problem with the column name...

What is the EXACT name of the column in the table?

[algorithm]

hi omniman, you are right.

The colomn names in database table upload_table are contenttype,filedata,filename, filesize,imgid,idno and title.