It's easy, if you are running the supplied Oracle driver on CF Enterprise and the datasource has BLOB retrieval enabled. If you are using the Thin driver on CF standard I can't guarantee it will work.
Either CFQUERY the table and use CFCONTENT to cfoutput the ToString() of the column, or use cffile to write the contents of the column to a temporary file and use cfcontent to serve it from there. The first method works great for images - other docs may need the second method. On 3/10/07, Nathan Chen <[EMAIL PROTECTED]> wrote: > Hi, All: > > Has anyone successfully outputted blob field to a CF template? How did > you do it? > > Nathan > > > -----Original Message----- > From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] > Sent: Friday, February 10, 2006 12:53 PM > To: CF-Talk > Subject: Re: Storing Documents > > I'm currently working on a real estate done in RubyOnRails that stores > property photos in tables. So far it doesn't seem too terribly > different than mssql. > > On 2/10/06, Ryan Guill <[EMAIL PROTECTED]> wrote: > > Has anyone done this in MySql? > > > > On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > > We just recently set up a document management system using MS > > > SqlServer. We ended up storing the documents inside the db. The > way > > > we structured it was to set up a table that had all of the meta data > > > about the document along with a file id (int) that linked up with a > > > file storage table that consisted of an id and a blob column. This > > > way, we can run queries against the meta data without slowing down > the > > > system with large blob columns. > > > > > > So far, the performance has been suprisingly snappy. Also, security > > > has been a lot easier to work into as we only have to secure one > > > resource instead of both a database and a file system. Another > > > additional benefit is that we've been able to share some documents > on > > > our extranet site without having to open another port for file > sharing > > > as all documents come from the db. > > > > > > > > > > > > On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > > > I have never stored actual documents in SQL Server. I have stored > the name > > > > and location and put the document into a directory on the file > server. > > > > However, a new "contracts" application I am working on is very > document > > > > heavy, mainly for storage... not much retrieval will be done. > > > > > > > > Currently when a new contract comes to be, a directory is created > for the > > > > contract and a slew of sub directories are also created over the > life of the > > > > contract. Sometimes the sub directories are standard across > contracts and > > > > some times they are not. Sub directories can get pretty deep in > terms of > > > > nesting. > > > > > > > > It seems it would be much easier (conceptually) to store the > documents > > > > directly in the database and let the structure of the database > dictate the > > > > "hierarchy" and relationships instead of creating a new directory > for each > > > > contract and trying to figure out which subdirectories are needed > or already > > > > exist, etc. > > > > > > > > When needed, the documents would be accessed via the > application... however > > > > this would restrict direct access to the document outside the > system. > > > > Anyway, has anyone taken the approach of storing documents > directly in a SQL > > > > DB, and if so, how was performance etc... > > > > > > > > Thanks! > > > > > > > > Tango > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
