Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:15573
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Reply-To: <Jared.Williams1@ntlworld.com>
To: "'Thies C.  Arntzen'" <thies@thieso.net>,
	<internals@lists.php.net>
Date: Thu, 24 Mar 2005 11:32:40 -0000
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcUwY7Bw1Kx6lfB8S5yCnStBNKItGQAAQPJA
In-Reply-To: <d1u7n1$h71$1@sea.gmane.org>
Message-ID: <20050324113223.HNKP10174.aamta07-winn.mailhost.ntl.com@win2ks>
Subject: RE: [PHP-DEV] pdo: cannot send NULL values thru bound parameters.
From: jared.williams1@ntlworld.com ("Jared Williams")
References: <d1u7n1$h71$1@sea.gmane.org>


> $stmt = $this->prepareStatement('insert into bla (name) 
> values (:name)'); $name = NULL; var_dump($name); // $name is 
> NULL $stmt->bindParam(':name', $name); var_dump($name); // 
> $name is an empty string
> 
> am i overlooking something obvious?

$stmt->bindParam(':name', $name, PDO_PARAM_NULL);

Or 

$stmt->bindParam(':name', $name, is_null($name) ? PDO_PARAM_NULL : PDO_PARAM_STR);

Is what I've been using, and works. http://pecl.php.net/bugs/bug.php?id=3391 was the original bug report I opened, that's since been
fixed.

Jared