Displaying alternate image when image source not found
I am creating a dynamic ASP VBScript page, which gets data from an Access database.
In the database, there is a field which holds a URL to an image. I can get the image to display fine, but where there is no file that matches the URL (i.e. a missing image) I want to display an alternative, default image (e.g. one that says "Awaiting Image"). The field is never blank, but the image file may not exist for all records in the database.
I think what I am trying to get to is the following:
If file exists (using URL from database to get location of image file) then
display image using the url from the database as the image source
display default image - hardcoded in program
I have had a go and come up with the attached but I get an error with my if statement.
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists (server.mappath("<%=(Recordset1.Fields.Item("ImageLocation").Value)%>")) Then
<img src="images/awaitingimage.jpg" width="243" height="239">