Using database functions on query

[Surt]

Hi, first, great lib!

I'm triying to set a date field using NOW() in mySQL, is this possible with idiorm?

$content->created = 'NOW()';

does escape and fill the database with wrong data 0000-00-00

[olivierphi]

+1
This would be a great feature ! (maybe with the use of a dedicated "Expr" class, like Zend_Db_Expr in Zend Framework ?)

[brianherbert]

+1
I'm not sure if this is being considered but I want to throw in my support here.

[robbiesmith79]

+1
I need support for ifnull() on the column selection but that test is getting wrapped in quotes and MySQL is throwing an error that 'ifnull(..)' is not a valid column. It would be cool if there was a parsing method on all select columns to detect the presence of specific database function name calls to NOT add quotes around them. I guess for now we'll have to use raw queries for the difficult queries.

[dr-impossible]

For the time being, you could use date('c'). This php function will return a string compatible with TIMESTAMP fields.