FuelPHP Forums

mantinia

I want to use MySQL function in where section.

For example:

$q = Model_Foo::query()->where(DB::expr('YEAR(birthday)'), '=', 1980);

* `birthday` field type is datetime.

But this code doesn't works. It returns ErrorException 4096.

How should I do? Please help.

I'm using ver. 1.5

Harro

I'm not sure DB::expr() was supported in where() clauses back in 1.5.

What is the exact error message you get?

mantinia

Thanks to your response.

The message is here.

Argument 1 passed to Orm\Query::_parse_where_array() must be an array, object given,

called in /path/to/fuel/packages/orm/classes/query.php on line 529 and defined

Harro

As I expected, you can not use DB::expr() in 1.5.

mantinia

Thank you. I look for the another way.

Harro

Upgrade to 1.7.1 (or even 1.8/develop) would be the logical fix for this?