Re: scalars in sql statement

[Felix Geerinckx]

Romina Drees Wrote:
-------------------------------------------------------

> I've a problem with filling in values into a table through following statement:
>
> $dbh->do('INSERT INTO protein (sequence) VALUES ($1)');

Single quotes do not interpolate variables in Perl.

But it's better to use placeholders anyway:

$dbh->do('INSERT INTO protein (sequence) VALUES (?)', undef, $1);

--
felix
Please use BBCode to format your messages in this forum.