Nobody able to help? I re-wrote the script to use the filesystem as we had to meet deadline but I'd still be interested if someone can advise how to retrieve a PDF or other file [other than an image] from a Database. Thanks, Chris. > -----Original Message----- > From: thelist-bounces at lists.evolt.org [mailto:thelist- > bounces at lists.evolt.org] On Behalf Of Chris > Sent: 15 December 2005 10:20 > To: thelist at lists.evolt.org > Subject: Re: [thelist] Retrieving OLE File from Access DB with Classic ASP > > > Why are you storing the file in the database? > I knew someone would ask and I have my excuse ready. I chose to store > both > the PDF and image in the database for ease of backup - simply download the > database. > > Security is not the issue as the files are all freely available to > download > from the site. The site will hold a maximum of 70x 250kb PDFs at any one > time and will be low traffic - maybe 100 visitors per day max. > > Technically I know it's not the best solution but I think it should be > fine > for this site. > > Can anyone advise how I would stream the file back out of the database? > > Thanks. > > > > Chris Dempsey wrote: > > > > > I have written code to take a PDF file and insert it into an Access > > > Database field via a form and file upload script. Unfortunately I'm > > > struggling to get it back out. > > > > Why are you storing the file in the database? Your Access file is going > > to end up the size of a cow. > > > > Why not upload the file to a folder, and store only the filename in the > > DB? > > > > If the concern is unauthorised downloading of the file, it should be > > possible to upload the file to a folder outside of the web root, and > > provide an ASP-based means to download it for an authenticated user. > > > > I haven't done this, but believe it to be possible - can anyone confirm? > > I'm going to be building something similar soon. > > > > Cheers > > > > Ian > > > > -- > > _________________________________________________ > > zStudio - Web development and accessibility > > http://zStudio.co.uk > > > > Snippetz.net BETA - Online code library > > File, manage and re-use your code snippets online > > http://snippetz.net > > > > -- > > > > * * Please support the community that supports you. * * > > http://evolt.org/help_support_evolt/ > > > > For unsubscribe and other options, including the Tip Harvester > > and archives of thelist go to: http://lists.evolt.org > > Workers of the Web, evolt ! > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt !