Displaying user image from sql database

palvin · June 17th, 2005, 11:53 AM

O.K. Vijay,

You know what? You have been a really great help and guess what?
you got it right buddy, the problem was that the CHAR was only length = 1. So I changed its length to 15. And I am only passing one parameter UID. So it is working perfectly now ( I am calling THEFILE instead of PicName). Thanks for bearing with my ignorance. I am beginner on ASP and SQL but you have been a great help. This is the best forums I have ever been.

Great Job.
Thanks Again

palvin · June 17th, 2005, 12:18 PM

Hello I was wondering if you can help to put a check on the procedure so that If there is no image then I can display a default image or not display any image at all because right now if there is no image at all I am getting an error

*****************************
ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/instantmessage2.asp, line 0
******************************************

I am using the procedure as follows

*******************

<%
Set ConnFM = Server.CreateObject("ADODB.connection")

        ConnFM.open "DSN=name; uid=user; pwd=password"
        FM = "Execute sproc_IMTest '" & UID & "'"
    Set ORsFM = ConnFM.Execute(FM)
%>

******************
I tried some methods but not that effective.
Thanks.

happygv · June 17th, 2005, 04:08 PM

That is because, you havent check for EOF before trying to access it, so in case you get no image for any user, you end up with this error.

Code:

Set ORsFM = ConnFM.Execute(FM)
IF not ORsFM.eof then
    'try to display data
Else
    'No data resulted from the proc, which you can use to display default image or ignore
End IF

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

palvin · June 22nd, 2005, 09:03 AM

Thanks a lot Buddy.

Works like a charm now. I really appreciate your help.

rajkvlp · July 6th, 2005, 05:09 AM

thanx to both of u...i learned a lot from u...