FuelPHP Forums

Thomas Edwards

Trying to send a DB expression as an array in a related model.

Model_Market::find($market, array(
	'related' => array(
		'events' => array(
			'where' => array(
				array(Db::expr('YEAR(`date`)'), '=', $year),
			),
		),
	),
))

Returns: Argument 1 passed to Orm\Query::_parse_where_array() must be of the type array, object given

Swapping `array(Db::expr('YEAR(`date`)'), '=', $year)` for `array('date', 'LIKE', $year.'%')` works but isn’t very efficient.

Syntaxlb

Hi,

I suggest you to use Db::expr() with query function.

Model_Market::query()
	->related('events', array('where' => array(array(\Db::expr('YEAR(`date`)'), '=', $year))))->get();

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion