That's it. I can't believe I forgot to turn "enable BlOB" when I updated the dsn today. Thank you!
Nathan -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, August 16, 2008 9:47 PM To: CF-Talk Subject: Re: CFContent tag First, check that your datasource has the "enable BLOB" checkbox ticked. On Sun, Aug 17, 2008 at 11:44 AM, Nathan Chen wrote: > Hi, All: > > I have a query that selects a BLOB field (embedded file) from a table. > Then I use cfcontent to output the string to the browser. The code has > running fine until today all of a sudden it won't display the files. All > the files in that BLOB field are pdf files. The code looks like this: > > <cfquery name="get_doc" datasource="#dsn#"> > > SELECT contents > > FROM DOCUMENT > > where Document.PrimaryKey=#url.DocPK# > > </cfquery> > > <cfcontent type="application/pdf" variable="#get_doc.contents#" > reset="yes"> > > When the page is run, Adobe Reader is open but with an error message > saying "The file is damaged and could not be repaired." When things like > this happen, where should I look into it? Thanks. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
