Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Coding for picture display


Message #1 by Jefferis Peterson <jefferis@p...> on Mon, 23 Sep 2002 14:21:29 -0400
Jefferis Peterson,

For this you should better not use relative link. Use the absolute path to store in your database.

It is ok, if you planned to have thumbnails folder under each and every other folders.

Once you retrieve the value from the SQL to recordset, use

if it is an image to be displayed on browser,
Response.write "<img src='" & rs.Fieldname & "'>"...............

if it is a URL to be displayed as a link
Response.write "<a href='" & rs.Fieldname & "'>" & rs.fieldname & "</a>"............

Cheers!!!
Vijay G


Jefferis Peterson wrote:If you have an imageURL stored in your database as a relative link like
folder is thumbnails/image.gif,

How do you code it so the image displays on the page rather than the url
text when the field is called from the database?

Jeff
~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.net
Tel .  xxx-xxx-xxxx
ICQ 19112253

http://www.Slippery-Rock.com - 7,000 hits per year




---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!

  Return to Index