On Thu, May 18, 2017 at 11:38 AM, Lester Caine <les...@lsces.co.uk> wrote:
> 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.
>
You can bind `NULL` pretty much with any PDO type - PDO::PARAM_NULL is not
needed to do so.
Marco Pivetta
http://twitter.com/Ocramius
http://ocramius.github.com/
