I have inserted a small zip file that contains all of my sales report
information into a blob field in a mysql database.
Each days sales reports will be around 63 to 120k. So I have used the
large blob type.
I wrote the file into the database using the load_file() function in
mysql.
Now in my perl script I retrieve the file into a string. I then print
that string to a file.
I open that file and it shows one of the files then gives me an error.
Here is my test code...
my $sth = $dbh->prepare("select salesjournals from sales_detail where
date='2003-06-02'");
$sth->execute;
my $zipfile = $sth->fetchrow_array;
open (OUT,">out.zip");
print OUT "$zipfile";
Also is it a bad idea to store these small zip files in the database
like this? You figure we have 20 or so zip files like this a month. It
would be nice to just tell the database that the account needs to see
the report detail for date X and have it dump the reports back. Rather
then having to keep all of these files on the drive. Plus one backup of
the database backs up everything.
Paul
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
