Display an image based on pathname

[jPaulB]

Hi Folks,

I'm playing with the notion of maintaining a database with an inventory table. One of the fields in the inventory table is for the image associated with an item, and the fieldname="loc".
That field is text based so it'll read "..\data\OneOfManyImages.gif"

Correct me if I'm wrong...

Dim objConn, rsSigns
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "inventory"
Set rsSigns = objConn.Execute("SELECT * FROM inventory WHERE fam ='Decorative Signs' ")

rsSigns is a recordset containing all of the records in inventory where the fam field is "Decorative Signs" and the value of rsSigns("loc") would be "..\data\OneOfManyImages.gif"

Question: What is the right syntax to display the image? The following statement isn't right:
<img src=rsSigns("loc") width="140" height="140" border="0">

Thank you,
-Paul-

[russell_g_1]

<img src="<%=rsSigns("loc")%>" width="140" height="140" border="0">