Display PDF Stored as OLE Object

[RandyWheeler]

I have an Access database that has a field defined as an OLE Object to store
PDF files. I have seen the posts related to using cffile and cfcontent but
cannot get things to work. The problem seems to be generating the pdf file
from the database. My code looks like the following:

<cfoutput>
<cffile action="write" file="Document.pdf"
output="#toBinary(mydata.myfield)#"/>
<cfcontent type="application/pdf" file="Document.pdf">
</cfoutput>

If anyone has any insight I could sure use it. And a code example would be
greatly appreciated.

Randy

[Rick]

I never store files in a database. What I do is I use a text field with a
path to the file and display it that way.


"RandyWheeler" <webforumsuser@macromedia.com> wrote in message
news:dqufvc$ki7$1@forums.macromedia.com...

>I have an Access database that has a field defined as an OLE Object to
>store
> PDF files. I have seen the posts related to using cffile and cfcontent
> but
> cannot get things to work. The problem seems to be generating the pdf
> file
> from the database. My code looks like the following:
>
> <cfoutput>
> <cffile action="write" file="Document.pdf"
> output="#toBinary(mydata.myfield)#"/>
> <cfcontent type="application/pdf" file="Document.pdf">
> </cfoutput>
>
> If anyone has any insight I could sure use it. And a code example would
> be
> greatly appreciated.
>
> Randy
>
>

[philh]

Take baby steps. Run just the CFFILE tag, and see if you can find the file on
the server. Use full pathing in your tags so there's no mistake about where
the file is being written to or retrieved from.

[RandyWheeler]

Rick,

That was my plan B. I will take your advice. Thanks.

Randy