Re: File download from BLOB

[bluescreen]

You're almost there. The BLOB out of mysql is an scalar with binary content, then after setting the proper headers like you doing on the Apache2's example. you have to print the contents of the blob you get from the DB

[wolfie7873]

OK, getting there: Here's what I've got that provides the proper download dialog:

$r->content_type('application/x-download');
$r->err_headers_out->add('Content-disposition' => ("attachment; filena
+me=$filename"));

my ($st,$sth) = ();
$st = "SELECT bin_data FROM forms WHERE filename = '$filename'";
$sth = $dbh->prepare($st) or die "Prepare Failed! " . $st . $dbh->errs
+tr();
$sth->execute() or die "Execute Failed! " . $st . $sth->errstr();
my $filedata = $sth->fetchrow();
$sth->finish();

$m->print($filedata);
return;

But the PDF is un-openable upon return. Is that a transmission problem, or a db problem or what?

[Eliya]

But the PDF is un-openable

You haven't mentioned what platform you're on, so this is just a guess...

Often, the issue rendering files un-openable is inadvertently having applied linefeed translations to binary formats (such as PDF).  So try using binmode on the file handle $m before writing the blob to it.