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")
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">