Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:24033
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Message-ID: <448967F6.4040003@php.net>
Date: Fri, 09 Jun 2006 14:22:14 +0200
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: PHP Developers Mailing List <internals@lists.php.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: [Fwd: fetch() returning false for empty datasets]
From: lsmith@php.net (Lukas Smith)

Forwarding here.
Maybe it got lost inbetween the spam attacks, maybe its just not 
interesting but lets open up the topic to a larger audience :)

-------- Original Message --------
Subject: fetch() returning false for empty datasets
Date: Mon, 05 Jun 2006 11:41:12 +0200
From: lsmith@php.net (Lukas Smith)
To: pecl-dev@lists.php.net
Newsgroups: php.pecl.dev

Hi,

the following script outputs "false" (at least on whatever pdo version
is bundled with 5.1.4):

$sql = 'SELECT 1 FROM dual WHERE 1=0';
$stmt = $dbh->query($sql);
var_dump($stmt->fetch(PDO::FETCH_ASSOC));

all other RDBMS extension we have return null in this case, which seems
to be the right thing too ..

regards,
Lukas