Hi, All: I have an application that requires storing documents inside Oracle 10g. I am having hard time knowing how to output the blob field to a CF template. Has anyone done this before?
Say, I have records: ID Title Content (Content is the blob field that stores the document, e.g. pdf file) How do I output Content field directly to CF template? Any pointer is appreciated. Nathan Chen -----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 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
