ansaurus

Question

Error opening PowerPoint file using cfcontent

Answer 1

+1 A:

If you're just passing the name of the file as the variable argument that's incorrect. You need to provide a binary variable in the variable argument. If you just have the file on disk, then you need to use the file argument with a full drive path to the powerpoint file itself.

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags%5Fc%5F11.html

<cfcontent type="#qry.contentType#/#qry.contentSubType#" file="#ExpandPath(qry.documentData)#">

Dan

Daniel Short 2009-09-23 02:15:49

I'm passing the binary. Document documentData is the binary field stored in the database.

Don 2009-09-24 00:31:01

I see, I missed that in the sample code... In that case, what *exactly* happens when you run your code. As Antony asked, "What error do you get?" Also, can you inspect the headers when you download a word doc versus a powerpoint file? There may be a difference there as well.

Daniel Short 2009-09-24 13:17:11

It opens powerpoint and gives me the following error: PowerPoint can't open this file, because it is in use by another user. One other thing, I can save the file to a drive but when trying to open it, powerpoint can not open it because it says it is corrupt.I will look at the headers and get back to you soon. Thanks

Don 2009-09-26 00:29:45

Are you sure that your file is valid in the database? Try loading one directly off of disk and see what happens...

Daniel Short 2009-09-26 03:22:26

I will try that and let you know.

Don 2009-09-28 15:46:25

Uploading and downloading to disk work fine for me.

Don 2009-09-30 01:10:51

But I need to get it to work with the database.

Don 2009-09-30 01:12:25

I'm using the same upload code to the database and to the disk.The upload looks the same:To Disk:cffile action="UPLOAD" filefield="FileName" destination="#myDestination#" nameconflict="MAKEUNIQUE" accept="application/pdf,image/jpeg,application/msword,application/vnd.ms-excel,image/jpg,image/pjpeg,image/gif,application/vnd.ms-powerpoint,image/tiff" attributes="Archive"To Database:cffile action="upload" filefield="#arguments.fileName#" destination="#arguments.fileDestination#" nameconflict="makeunique" accept="#arguments.fileTypesAllowed#"The file be should valid in the db.

Don 2009-10-01 02:03:37

One more thing. I used firefox and I'm get this error when I click on the document name: powerpoint can't read the outline from filename. no text converter is installed for this file typeIt really looks like my ppt file is jacked up but I don't know were it is happening.

Don 2009-10-01 03:03:48

What code are you using to save it to the database? And you've verified the file is good before the upload, correct?

Daniel Short 2009-10-01 13:01:09

Daniel thanks for your help so far and sorry for the delay. I was working on another project. The file is good in the database. I wrote a .net app and it opens it ok. I still can't get it to open in coldfusion.Below is the code that I use to open the document. Note this code works fine for other type of documents.cfheader name="content-disposition" value="attachment; filename=#qry.clientFile#"cfcontent type="#qry.contentType#/#qry.contentSubType#" variable="#qry.documentData#"

Don 2009-10-15 01:32:29

Try using a generic mime type and see if that makes a differnece, type="application/octet-stream"

Daniel Short 2009-10-15 13:50:15

That did not work either. I even took of the type attribute off all together. Also, proceded to removed the cfheader statement. Same results, except it save it to disk. Then powerpoint could not open the file.

Don 2009-10-16 01:15:59

In that case I'm at a total loss.... If you can download the powerpoint before it goes into the database, but not after, then I can only assume something is getting broken in process of saving the data to the DB. If you're successfully saving other binary objects to the DB, then I don't know where to tell you to look...

Daniel Short 2009-10-16 16:23:32

Feel the same way. I'm going save all power point files to disk and any other file types to the database. It will not be hard but it is pain to do.Thanks for your help.

Don 2009-10-18 03:16:17

ansaurus

tags:

views:

answers:

Error opening PowerPoint file using cfcontent

related questions