On 2011-02-23 13:53, HACKER Nora wrote:
my $sql = "select secondname || ' ' || firstname from supp_verantw_v";
my $sth = $dbh->prepare($sql);
my $personen = $dbh->selectall_arrayref($sql) or die "geht net: $!\n";
You are not usubng the $sth that you set up, why?
my $sth = $dbh->prepare( <<'SQL' );
SELECT
CONCAT( secondname, " ", firstname ) AS _name
FROM
supp_verantw_v
SQL
$sth->execute;
while ( my $row = $sth->fetch ) {
my $name = $row->[0];
...
}
Also check out bind_values().
--
Ruud
--
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
http://learn.perl.org/