Re^2: Using BLOB fields with Class::DBI and MySQL

I didn't bother cluttering up the post with code, as I didn't think it was particularly instructive. But here's a sample: The database setup code:

package MyDatabase::Candidates;
use base 'MyDatabase::DBI';
MyDatabase::Candidates->table('CANDIDATES');
MyDatabase::Candidates->columns(
 All => qw/CANDIDATEID CV/);
[download]

Then the code that's supposed to be doing the setting:

my $filehandle = $self->query->upload('cv');
my $cvfile     = do { local $/; <$filehandle> };

$candidate->CV($cvfile);
[download]

Comment on Re^2: Using BLOB fields with Class::DBI and MySQL Select or Download Code

Replies are listed 'Best First'.
Re: Using BLOB fields with Class::DBI and MySQL by jonadab (Parson) on Jul 25, 2005 at 11:35 UTC
Try adding this: `$candidate->update();`	[reply] [d/l]