The DSN settings need to be adjusted to allow LOBs. I had this issue with the images half-loading, but got it fixed by the time I got to the binary "attachment" filetypes.
This totally explains why your Word docs are failing; only the first 64k is making it into the database! Try uploading a small Word doc (less than 64k), I'll bet it works! Francisco can fix the DSN for you. Take Care, Seth Mark Davis <[email protected]> wrote: >Not having complete luck on this. Couple of issues > >-- some images (jpg) show just fine when served up using cfcontent. Some >are only halfway rendered. > >-- PDFs can't be opened. Reader 9.0 says The file is damaged and cannot be >repaired.I can open the original PDF just fine. Also, I am checking the >file just before the cfcontent tag is it is a valid binary file. The >original file is 978K, but when I serve the stored version and save it >(instead of opening) its only 63K. > >Here is the code being used to serve the files > ><cfheader name="Content-Disposition" >value="attachment;filename=mw197788-colorectal-screening-chinese.pdf"> > ><cfcontent type="application/pdf" >variable="#request.TAPAttachment.attachment#" reset="true"> > >Thanks for any assistance. Happy friday > > > >On Thu, Jul 22, 2010 at 2:18 PM, Aaron Rouse <[email protected]> wrote: > >> Yes, although given the vast differences in file sizes I would have to play >> with how long I slept before deleting files. It really is just as much >> trouble as setting up a Windows scheduled task to execute forfiles. I >> highly doubt either solution has an advantage over the other. What I'd >> really like to see is ColdFusion being better with how it accesses files. I >> have not tried this in ColdFusion 9 but seen people complaining about the >> problem in that version as well. >> >> >> On Thu, Jul 22, 2010 at 2:03 PM, Mike G <[email protected]> wrote: >> >>> You could use a folder watcher gateway to delete the file. In the onadd >>> event just sleep for ten seconds and then delete it. >>> >>> M >>> >>> On Jul 22, 2010 1:58 PM, "Aaron Rouse" <[email protected]> wrote: >>> >>> We are pushing out files for a proprietary program and honestly do not >>> remember why we do not push out the mime type for it. I know if the >>> programs are installed on the workstation that the files do open up. I >>> think on the Linux workstations they have to setup things in Firefox to >>> recognize what program to use. Surprisingly we have not run into latency >>> issues, the Oracle server is here in town but this application is used >>> across the globe. Most of the files are pretty small with the exception of >>> the printout files which can get enormous. >>> >>> We used to have a Java class for pushing them out but I got tired of >>> maintaining that and changed it to that CF code I posted up. We still do >>> though use a Java class to collect the files from the proprietary program >>> then use CF to read that, insert it into the database and delete the temp. >>> file. The deletion of the temp. file sometimes throws an error. Have found >>> CF just is not the best when you read and delete a file on the same page. >>> It does not always release the file quick enough after the read to allow >>> the deletion to happen. Going to just use Windows forfile tool to wipe that >>> directory via a Windows schedule task. >>> >>> One day I'd like to be given the budget to just change collection of files >>> to a web service. >>> >>> >>> >>> On Thu, Jul 22, 2010 at 1:48 PM, Chris Champion < >>> [email protected]> wrote: >>> > >>> > We did som... >>> >>> >>> -- >>> You received this message because you are subscribed to the "Houston >>> ColdFusion Users' Group" d... >>> >>> -- >>> You received this message because you are subscribed to the "Houston >>> ColdFusion Users' Group" discussion list. >>> To unsubscribe, send email to [email protected] >>> For more options, visit http://groups.google.com/group/houcfug?hl=en >>> >> >> >> >> -- >> Aaron Rouse >> http://www.happyhacker.com/ >> >> -- >> You received this message because you are subscribed to the "Houston >> ColdFusion Users' Group" discussion list. >> To unsubscribe, send email to [email protected] >> For more options, visit http://groups.google.com/group/houcfug?hl=en >> > >-- >You received this message because you are subscribed to the "Houston >ColdFusion Users' Group" discussion list. >To unsubscribe, send email to [email protected] >For more options, visit http://groups.google.com/group/houcfug?hl=en -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en
