...if objRS is your recordset object, and myImage is your image field name:<BR><BR><%<BR>if Len(Trim(objRS.Fields("myImage"))) = 0 then<BR> ' There wasn't an image - show it.<BR>else<BR> ' There was an image - show it<BR>end if<BR>%><BR><BR>Craig.
I have adapted the code however I am still getting a blank image (the one with the red cross in the middle)<BR><BR>if Len(Trim(objRS(3))) = "" then<BR>response.write "Sorry no picture available"<BR>else<BR>sHTML = sHTML + "<img src=""" & objRS(3) & """><BR>"<BR>end if<BR><BR>Any more ideas??
Try a different tactic. I'm asuming here that in your database the fields that don't contain an image read NULL, use:<BR><BR>IF IS NULL ObjRs.field THEN<BR>response.write "sorry no image available"<BR>ELSE<BR>response.write "<img src='" &ObjRs.field &"'>" 'etc<BR><BR>Hope that helps, give a better example of your code if it doesn't