Hi again jasmine,
I thought you had forgotten about us! :) Generally, it's easier to store a pointer to the picture in a database, because HTML can't reference the picture the way you have set up. HTML, in order to display a picture in the way you want, needs to know where the picture is stored on your server. If the picture itself if stored in the DB, you'll have to pull the picture out of the database in order to use it in your HTML.
This being said, the easiest way to reference the image would be to assign it a unique number in the database (001, 002, 003, ad nauseam...) and then call that number as part of the image name (image001.jpg, image002.jpg, image003.jpg, etc...). Try something like this for example:
<img src="images/image<%=rs("id")%>.jpg"
This way, you can also check for a value of "none" and create an image for that (imageNone.jpg - for example).
If you REALLY want to have the image stored IN the database, then you'll have to approach things in a MUCH more complicated and difficult way. You will not only have to assign the ASP code to point to the object, but you'll also have to tell the computer what KIND of an Object it is by setting it's MIME (Multipurpose Internet Mail Extensions)type. This MIME type tells the browser what kind of information to expect, and how to interpret it.
An example of setting a MIME-type is below:
<%Response.ContentType = "image/jpeg"%>
This tells the browser that this image is of the type JPEG (or jpg, etc...).
What you'll have to do, instead of referencing the file in the database directly, is reference a page which pulls the info OUT of the DB and puts it into the right format like so:
<img src="sqlbitmap.asp">
What happens here is then you write an ASP page that calls this data from the database and writes it to the page (save the below as "sqlbitmap.asp"):
<%
Response.Expires = 0 'This makes sure the data is the newest
Response.Buffer = TRUE ' Sends everything back to browser
Response.Clear 'Clear out the Response Object
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=Your_DSN_Info_Goes_Here"
Set rs = conn.Execute("SELECT image FROM table WHERE whatever")
Response.ContentType = "image/gif" ' Set the MIME type here
Response.BinaryWrite rs("image") 'Send the data to browser
rs.Close
Set rs=Nothing
conn.Close
Set conn = Nothing
Response.End ' Clear the Response Object
%>
Note that in this above example, you will absolutely NEED to know what KIND of data is stored in the DB. Otherwise the MIME type willbe just guesswork and will be absolutely worthless!
*Whew* That's a lot of coding, ain't it?
Good luck, and I hope this answered your question.
Jim