Hello Cookers,
I am facing a little problem with a query. I want to display a random selection of products (9 out of 20).
Before ORM, this code works like a charm:
// LIMIT
$this->setState('list.limit', 9);
// ORDER
$this->addOrder( 'rand()' ); Query Result : ORDER BY rand(), a.dname asc;
Now, I am trying to update my code with ORM but the RAND() do not work (no warning, no error) but ORDER BY is default.
My code :
// LIMIT
$this->setState('list.limit', 9);
// ORDERING
$orderCol = $this->getState('list.ordering', 'dname');
$orderDir = $this->getState('list.direction', 'RAND()');
$this->orm->order(array($orderCol => $orderDir));
break;Query Result: ORDER BY a.dname ASC;
Any idea to hold that, chief ?
