Re: SQL queries using dynamic array

[Enlil]

in reply to SQL queries using dynamic array

Here is one way (granted it is not tested):

my @values = qw/Otago Auckland Nortland/;

#Quote Values to be safe
my $values = 
  join("," 
       ,map { $dbh->quote($_) } @values 
      );

my $statement = "
  SELECT c_email, c_first, c_last 
    FROM tblClient, tblGroup, tblRegion 
   WHERE  tblGroup.g_name = 'motel' 
     AND tblRegion.r_name IN ( $values )";

my $sth = $dbh->prepare($statement);
$sth->execute();

HTH

-enlil

[jhourcle]

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.

[NodeReaper]

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

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