If you store the image's file path in a database....
Access that path through your regular query as usual and reference that in
your <img src="#queryname.image_field_name#"> tag....of course you may want
to also store the image's actual width and height properties as well, and
maybe an alt description (in the pursuit of well-formed HTML).....and pull
them into the tag, but, you can get away without the width, height and alt
info.
Does this help?
Erika
--------------------------------
AIM: WebErika5
Yahoo: WebErika
MSN: WebErika
AskMe.com Expert: WebErika
--------------------------------
Erika L. Walker
Vice President
RUWebby, LLC
201-370-4272 (c)
973-244-9120 (o)
153 Rutgers Lane
Parsippany, NJ 07054
--------------------------------
Website Design/Programming
Database Integration
Allaire Partner - ColdFusion
--------------------------------
-----Original Message-----
From: Brad Squires [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 1:19 PM
To: CF-Talk
Subject: Database Images
This is a multi-part message in MIME format.
------=_NextPart_000_0002_01C0B382.A20C2840
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
When you store an image in the database, how do you go about displaying it
on the HTML page? Right now, I am simply storing the URL in the DB to the
image file on the hard drive, but looking to storing them in the actual SQL
Server dataabase as another solution. I just wanted to find out how one
would go about doing this and get any feedback from those who have used this
technique.
Brad Squires
------=_NextPart_000_0002_01C0B382.A20C2840
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D250591518-23032001>When =
you store an=20
image in the database, how do you go about displaying it on the HTML =
page? Right=20
now, I am simply storing the URL in the DB to the image file on the =
hard=20
drive, but looking to storing them in the actual SQL Server dataabase as =
another=20
solution. I just wanted to find out how one would go about doing this =
and get=20
any feedback from those who have used this =
technique.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D250591518-23032001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D250591518-23032001>Brad=20
Squires</SPAN></FONT></DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_0002_01C0B382.A20C2840--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
