in reply to Putting mod Storable output into MySQL

Do you get the same error if you use a proper placeholder (keeping the value out of the string, replacing it with "?", as documented under "placeholders" in DBI)?

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.

  • Comment on Re: Putting mod Storable output into MySQL

Replies are listed 'Best First'.
Re^2: Putting mod Storable output into MySQL
by cormanaz (Deacon) on Oct 15, 2005 at 16:04 UTC
    Yes I do, presuming I'm doing the placeholder operation correctly 
    my $frozen = freeze($data);
my $command = "insert into blobtest (key,blob) values (1,?)";
my $sth = $dbh->prepare($command);
$sth->execute($frozen) || die "Could not execute MySQL statement: $com
+mand";

    [download]
    This last line gives the same error.
[reply]
[d/l]

In Section Seekers of Perl Wisdom