in reply to Dereference an array reference
this is what placeholders were designed to do.my $slobbo = "select * from bleh where whatever = "; ... ... my $sth = $connection->connection->prepare($slobbo.$thangsname );
foreach my $var (@list) $sql = $l_dbh->prepare("INSERT activity (activity_num) VALUES (?)"); @l_sqlparams = ($var); $l_result=$sql->execute (@l_sqlparams) or die 'no';
see?
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: (Boo) Re: Dereference an array reference
by fmogavero (Monk) on Apr 19, 2001 at 18:02 UTC | |
Re: (Boo) Re: Dereference an array reference
by fmogavero (Monk) on Apr 19, 2001 at 19:24 UTC | |
by boo_radley (Parson) on Apr 19, 2001 at 19:28 UTC |
In Section
Seekers of Perl Wisdom