Re: called with 19 bind variables when 20 are needed


good chemistry is complicated, and a little bit messy -LW
	PerlMonks

Re: called with 19 bind variables when 20 are needed

by gav^ (Curate)

on Jul 20, 2002 at 22:42 UTC ( [id://183693]=note: print w/replies, xml )

Need Help??

in reply to called with 19 bind variables when 20 are needed, error

Personally I find something like this easier to read and definatly less error prone, the field names are only in one place:

my @fields = qw/cat itemid price des longdes size o1n o1o o2n 
                o2o o3n o3o c1n c1v c2n c2v c3n c3v small large/;

my $sql = sprintf 'INSERT INTO items (%s) VALUES (%s)',
                join(',', @fields), join(',', (?) x @fields);
              
$dbh->do($sql, undef, map scalar param($_), @fields);
[download]

gav^