use <CFX_GETIMAGE>
http://www.funjunkie.co.uk/link.cfm?CMBA4CQ8
display.cfm
===========
<img src="myImage.cfm">
myImage.cfm
===========
<CFX_GetImage
DataSource=#DataSource#
User="#SQLUser#"
Password="#SQLPassword#"
SQL="SELECT GeoImage FROM Images WHERE Image_ID = #url.ImageID#"
OutPut="TEMPFILE">
<CFHEADER NAME="Pragma" VALUE="no-cache">
<CFCONTENT TYPE="image/gif" DELETEFILE="YES" FILE="#IMG_FILE#">
> -----Original Message-----
> From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
> Sent: 15 March 2002 10:24
> To: CF-Talk
> Subject: BLOB
>
>
> Hi
>
> My Image is stored in SQL Server 2000, with image datatype. How can I
> get Image back in coldfusion from that BLOB and display image
> on browser
> (IE)?
>
>
> Shahzad Butt (Development Engineer)
>
> JJ FastFood Distribution Ltd.
> Office: +44 (0) 1992 701 722
> Mobile: +44 (0) 7803 584 873
> Fax: +44 (0) 1992 701 604
>
> 7 Solar Way, Innova Park, Enfield, London, EN3 7XY
>
>
> ********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the use of the individual or
> entity to whom they are addressed. If you have
> received this email in error please notify [EMAIL PROTECTED]
> or call +44 (0) 1992 701 704. Please note that any views
> or opinions presented in this email are solely those of
> the author and do not necessarily represent those of
> JJ Fast Food Distribution Limited. Finally, the recipient
> should check this email and any attachments for the
> presence of viruses. The company accepts no liability
> for any damage caused by any virus transmitted by
> this email.
> ********************************************************************
>
>
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
