Re^2: SQL queries using dynamic array

[jhourcle]

in reply to Re: SQL queries using dynamic array
in thread SQL queries using dynamic array

For those who like bind variables:

my $placeholders = join ( ',', ('?') x @values );
my $statement = <<"EOF";
  SELECT c_email, c_first, c_last 
    FROM tblClient, tblGroup, tblRegion 
   WHERE  tblGroup.g_name = ?
     AND tblRegion.r_name IN ( $placeholders )
EOF
my $sth = $dbh->prepare($statement);
$sth->execute('motel', @values);

[NodeReaper]

This node was taken out by the NodeReaper on Nov 19, 2008 at 11:24 UTC
Reason: [jhourcle]: dupe of Re^2: SQL queries using dynamic array and Reaped: Re^2: SQL queries using dynamic array

You may view the original node and the consideration vote tally.