Demerzel
Novice
Jun 14, 2011, 2:28 AM
Post #1 of 1
(233 views)
|
|
Mysql IFNULL NOT working in PERL
|
Can't Post
|
|
I have a problem with IFFNULL for SQL statement. Directly in MySQL it works fine. In Perl, it always return 1,
my $sdbq = $dbase->prepare("SELECT IFNULL((SELECT id FROM nodes WHERE ownerid=?),0)");
my $var =$sdbq->execute($row->{'id'});
print "ID:".$row->{'id'}."node:".$var."\n ";
mysql> SELECT IFNULL((SELECT id FROM nodes WHERE ownerid=1),0);
my $sdbq = $dbase->prepare("SELECT IFNULL((SELECT id FROM nodes WHERE ownerid=1),0)");
my $var =$sdbq->execute();
|
MAIN
SEARCH
WHO'S 
LOG 