Kevin, Try this: <cfsilent> <cfquery name="q" datasource="webdb"> ....Your query here... </cfquery> </cfsilent> <cfheader name="Content-Disposition" value="inline"> <cfcontent type="image/jpg" variable="#q.image_data#" reset="false" />
In CF7, you can stream directly from the database. Jon On Nov 14, 2006, at 11:52 AM, Kevin Cundick wrote: > Hi All, > > > > It has recently been required of me to pull a BLOB image from a Sybase > database to display on a webpage. Up to now I have never had a > need of > working with a BLOB in a database or anywhere else for that matter. I > have read through the list and found several options, none of which > have > been successful to me so far. I do have the datasource setup in > the CF > administrator to accept a BLOB. The method I am currently trying > looks > like this: > > > > <cfquery name="q" datasource="webdb"> > > select image_data > > from FACT_SHEET > > where fact_sheet_id = 5 > > </cfquery> > > > > <cfcontent type="image/jpeg"> > > <cfoutput>#ToString(q.image_data)#</cfoutput> > > </cfcontent> > > > > All this does is display the current URL in the browser. It does not > display anything else, not even if I put something else in there > for it > to display. > > > > I am running CFMX 7 using the Sybase driver that came with ColdFusion. > Any ideas on this would be very helpful and appreciated. > > > > Thanks, > Kevin > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260360 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
