Just pull the content, and use cfcontent + cfheader. If the data is base64()ed, toBinary() it first, but other than that, it's pretty straight forward.
Basically a example of serving images from a DB will get you there. I've even got an example lying around here somewhere, if needed. It's way easier than it seems it should be, really. -- Better a diamond with a flaw than a pebble without. Confucius On Thu, Nov 19, 2009 at 4:26 PM, Dave Watts wrote: > >> I have a client that required the flash file to be stored in an Oracle >> database. And now I am required to load Flash using an xml >> file that should be pulling its data from the database. I cannot store >> files on the server - so I'm trying to figure out if what I'm >> attempting is even possible. >> >> So far I've been able to create the xml. But note that the url is actually >> a physical file on the system. I can't do this. I have to >> retrieve the binary flash data from Oracle and do this same sort of thing. >> Help anyone? Ideas? > > You could certainly store the Flash file itself in a BLOB field, then > pull it out with CF, write it temporarily to the filesystem, then > serve it up. If you can't even write it temporarily to the filesystem > for some reason, you could conceivably use CFIMAGE with the > WRITETOBROWSER attribute, then wrap that in a CFSAVECONTENT tag and > rewrite the contents to use the generated URL with OBJECT/EMBED tags > instead ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
