Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:99097 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 20394 invoked from network); 18 May 2017 09:38:14 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 18 May 2017 09:38:14 -0000 Authentication-Results: pb1.pair.com smtp.mail=lester@lsces.co.uk; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=lester@lsces.co.uk; sender-id=pass Received-SPF: pass (pb1.pair.com: domain lsces.co.uk designates 185.153.204.204 as permitted sender) X-PHP-List-Original-Sender: lester@lsces.co.uk X-Host-Fingerprint: 185.153.204.204 mail4.serversure.net Linux 2.6 Received: from [185.153.204.204] ([185.153.204.204:52553] helo=mail4.serversure.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 56/ED-21791-58B6D195 for ; Thu, 18 May 2017 05:38:13 -0400 Received: (qmail 16138 invoked by uid 89); 18 May 2017 09:38:10 -0000 Received: by simscan 1.3.1 ppid: 16127, pid: 16130, t: 0.4386s scanners: attach: 1.3.1 clamav: 0.96/m:52/d:10677 Received: from unknown (HELO ?10.0.0.7?) (lester@rainbowdigitalmedia.org.uk@81.138.11.136) by mail4.serversure.net with ESMTPA; 18 May 2017 09:38:10 -0000 To: internals@lists.php.net References: <001401d2cfae$f7c64130$e752c390$@marcodor.com> Message-ID: Date: Thu, 18 May 2017 10:38:09 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.1.0 MIME-Version: 1.0 In-Reply-To: <001401d2cfae$f7c64130$e752c390$@marcodor.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-GB Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Re: [RFC] deprecate PDO::PARAM_NULL From: lester@lsces.co.uk (Lester Caine) On 18/05/17 09:15, Dorin Marcoci wrote: > Yes, null is a state, not a type. ->bindValue('Foo', PDO::PARAM_NULL) is > awesome. > So it should be deprecated and removed. ? One of the reasons for using 'prepare' is to set up a query which can be run several times and some of those passes may require that one of the parameters IS null. Easy enough with the array passed to Execute, but more difficult if you have used the PDO parameter handling. In my book being able to flag a parameter as 'NULL' for a pass is just as important as supplying a value, so while yes NULL is a state, it is also a valid value for a parameter. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk