Jon, I thought I should mention to you that it turns out that the problem I was having was related to the image not being stored properly in the database. I had our DBA put in several more and they worked perfectly using the method you suggested below.
Thanks for your replies! Kevin >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:260523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
