Issue Type: Bug Created: 2009-06-04T02:23:25.000+0000 Last Updated: 2009-08-17T19:31:20.000+0000 Status: Resolved Fix version(s): Reporter: Christoph Kempen (webpatser) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db_Adapter_Mysqli
Related issues: Attachments:
When using prepared statements I bind dates into the query.
$query = $this->db->query("select * from table where DATE( ? ) between from and to", array($date));
if $date is "2009-06-04" it works fine: DATE( "2009-06-04" )
But when $date contains "now()" the quotes should be left out: DATE( now() ).
It's not a big deal. But it makes my life a bit easier :-)
Posted by Christoph Kempen (webpatser) on 2009-07-10T01:54:07.000+0000
Nobody seems to reply on this... Too bad!
Posted by Josh Butts (jimbojsb) on 2009-08-17T19:31:19.000+0000
In the context of a prepared statement, parameter placeholders (?) may only be data values. The MySQL API does not permit you to bind NOW() as a parameter.
Have you found an issue?
See the Overview section for more details.