Hi,
How do I send HAVING statement to MySQL in CakePHP. I search in
api.cakephp.org, but I could not find it.
Something like this:
$this->set('users', $users = $this->User->find('all', Array('fields'
=> '*,
CASE
WHEN active = "1" THEN "A"
ELSE "I"
END as active_flag
', 'conditions' => $conditions, 'having' => Array('active_flag'
=>
'A'),'order' => $order)));
Thanks!
Dérico Filho
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
