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:260356
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
