backing up easier and I can always buy more RAM.
So to do this do I just write the content of the file to a Binary field and
store the File Type and then use CFFILE to create a temp file on the server
when it is requested?
I am running
Windows 2000 (will be 2003)
SQL Server 2000
CF5.0
On a DELL 1gig DUAL Pentium with 1 gig of RAM.
Thanks Ben
Rick
_____
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 8:51 AM
To: CF-Talk
It will be something along the lines of "binary" but may depend a bit on
your RDBS.
Just remember, you're going to have to pull it from the DB and store it
in RAM before you serve it this way. That can be taxing if the files
are big.
--Ben Doom
cfhelp wrote:
> I have been building a small document management system where Admins can
> upload a share files with clients without using FTP (A few other things).
>
>
> Right now the files are uploaded and stored in the users directory. I had
> seen something a while back about actually storing the file in SQL server
> and using CFCONTENT to produce the file for download. Anyone have tutorial
> on this or some example code? What datatype does the database field need
to
> be?
>
> Rick Eidson
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]