I had a hasAndBelongsToMany binding in my Charity Model as i normally would need all the “Causes” available along with Charity information and vice-versa. At one place i needed a specific number of “Causes” picked randomly from the database table. To make this work i had to add following two lines just before the $this->Charity->find call in my controller action:
$this->Charity->hasAndBelongsToMany['Cause']['limit']=5; $this->Charity->hasAndBelongsToMany['Cause']['order']='rand()';
and i was done.
Does someone has a better solution? Please suggest.
