in reply to Using BLOB fields with Class::DBI and MySQL

Hi,

Perhaps posting some of your code would help in answering the question.
Reading the node How do I post a question effectively? may also be a good investment of time.

Thanks,

Martin
  • Comment on Re: Using BLOB fields with Class::DBI and MySQL

Replies are listed 'Best First'.
Re^2: Using BLOB fields with Class::DBI and MySQL
by Anonymous Monk on Jul 25, 2005 at 10:58 UTC
    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]
[reply]
[d/l]
[select]
      Try adding this: $candidate->update();
[reply]
[d/l]

In Section Seekers of Perl Wisdom