Hello all!
I’ve beeing here for long time, but is my first post.
I have an active record query with several joins which is causing me troubles, and I’ve found that using STRAIGHT_JOIN solves the issue…
How could I insert that modifier in SELECT clause?
I have functions on it, so $criteria->select must be an array, but I haven’t found the way it works.
Well, after spending some hours, my solution involves extending whole CActiveFinder until change CJoinQuery::createCommand and build the $sql var as I want.
In the model:
public function getActiveFinder($with)
{
return new MyActiveFinder($this,$with);
}