Re: Store Flash File in database then load into Flash?
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
Re: Store Flash File in database then load into Flash?
I'll give that a try. I'm not supposed to write anything to the server. Sure makes the easy stuff tricky. Thanks, Dave! ~| 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:328555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Store Flash File in database then load into Flash?
> 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 of IMG. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more infor ~| 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:328552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Store Flash File in database then load into Flash?
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? Thanks! ___ #xmlString# ~| 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:328550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
