there is an example on www.aspfaqs.com, but I think it's a better idea to just store the URL to the image in the database.<BR><BR>You would store "/images/mypic.jpg" in a field called URL, and then display it like<BR><BR><IMG src="<%=rs("imgage_url")%>>
.. it depends on how the image relates though. often I just key the image to the primary key - so record 1 would link to 1.jpg and so on. one less field, I guess, though in some cases you have to check it exists with FSO. like I say, depends what you want.
but that's why I use another field<BR><BR>for SQL Server you could use the ISNULL function, (and for access the iif function)<BR><BR>SELECT ISNULL(image_url, 'nopic.jpg') FROM theTable<BR><BR>this saves the overhead of the FSO, and displays the nopic.jpg if no picture was found.