OK - I conquered the Flash file view but now I have something peculiar with PDF
files. I have narrowed in on the fact that the ones that work are simple PDF -
no graphics and small in size. The ones that do not work ("The file is damaged
and could not be repaired" message in PDF Reader) are larger with graphics
within.
_______________________________________________________
I store the PDF as binary by uploading the file, then using readbinary.
<cffile action="upload"
destination="#ExpandPath('#session.root#/tmpFiles/')#"
filefield="form.promoPDF" nameconflict="makeunique">
<cffile action="readbinary"
file="#CFFILE.serverDirectory#\#CFFILE.serverFile#"
variable="bPDF">
The PROMOPDF in the table is a BLOB/Oracle.
<cfquery name="insBlob" datasource="#dsn#">
INSERT INTO MSR_PROMOTIONS
( PROMOPDF )
VALUES( #bPDF# )
</cfquery>
So I think I saved it right.
_______________________________________________________
Now to get it out and display...
<cfquery name="qPromoImage" datasource="#DSN#">
SELECT PROMOPDF
FROM MSR_PROMOTIONS
</cfquery>
<cfcontent type="application/pdf" variable="#qPromoImage.PROMOPDF #" >
Adobe Acrobat error : File is damaged and cannot be repaired.
_______________________________________________________
Help...
Thanks!
Kim
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:327389
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
