I am continuing to get an SQL error, and my query is NOT working???
*Warning* (512)
<http://cda-insurance.com.w3developing.com/pre/cake/beta/plans/search>: *SQL
Error:* 1064: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'order = ('asc') AND conditions = (1)' at line 1
Here is my code:
*Plan Controller* Method search()
function search() {
$this->Plan->recursive = 2; //*** Modified by Jason: Recursion needs to be
corrected with better method. ***//
$active = $this->Plan->*getActive()*;
$this->set('plans', $this->paginate());
} // Trying to get $active to return to my results, but nothing is happening
at all except the above error and ALL results (query is not effective).
*Plan Model *Method search()
function getActive() {
$conditions = array(
'limit' => 10,
'order' => array('monthly_cost' => 'asc'),
'conditions' => array('PlanDetail.active' => 1) // Gets all active=1
plan_details.
);
return $this->find('all', compact('conditions'));
}
Anyone know why this is not working?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
