I have a frontpage database in my website that I need to pull an image from a file of about 75 images. I have about 250 database objects. How can I get my database link to pull an image of an object without having to create 75 or more individual links to the images. Example: The user would search for a Nissan Frontier. The database shows approximately 25 frontiers, each with an individual stock number, and 15 of them have a picture, in a file with the same stock number, available. How do I create a link that would SEARCH the image file and find the image with the matching stock number and display it? I currently have to create an individual link within a column for each individual stock number with a matching image stock number.

I know this can be done, but, how?

hopes this is what your looking for

Dim ImgFile
Set ImgFile = CreateObject("Scripting.FileSystemObject")
If ImgFile.FileExists("Path*") Then
'your code for the image . . .
End If


The "path" stand for file location on your system
(didn't try it on the web) + the file full name,
exmpl : "c:\images\Image.gif"

Thankyou, will give it a try and let you know. It may be a couple of days before I can get to it though. Thanks again, Chris