Help for this page

Select Code to Download


  1. or download this
    #prepare
my $sth = $dbh->prepare('SELECT * FROM people WHERE lastname = ? AND f
+irstname = ?');
...
[download]

But it's a bit cumbersome to adjust the bind values if the order chang
+es.
  2. or download this
    
$dbh->{pg_placeholder_dollaronly} = 1; # default is 0
my $sth = $dbh->prepare('SELECT * FROM people WHERE lastname = $1 AND 
+firstname = $2');