bevssi 0 Newbie Poster

I'm trying to display a .jpg photo into my report. I receive this error:

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal

I'm using this code:

strSQL = "SELECT oPeople.People_ID, oPeople.oPeople_TGCKFD,oPeople.Preferred_Name FROM oPeople Where oPeople.People_ID="& Session("ccpeopleid") & ""


Set rs = Conn.Execute(strSQL)

photo=rs("oPeople_TGCKFD")
pic="<img src=http://sg.brickriver.com/files/oPeople/" & photo & " >"
If isNull(photo) Then
pic=("&nbsp;")
End If

%>
<font face="arial" size="2">
<tr>
<td colspan="3" align="center" style="border-bottom:1px solid #ccc;"
</tr>
<tr>
<td><%=rs("Preferred_Name")%></td>
</tr>
<td><%=rs("pic")%></td>
</tr>


</table>
</td>
</tr>
</table>


I'm pretty new at this so this may be completely wrong. Can anyone help?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.