Re: cakephp query with subquery

Hi Ninjazhai,

2012/4/10 ninjazhai <ninjazhai30@gmail.com>:
> how do I convert this query to CakePHP find style?

First, I think that you would be a good idea to clean up your sql query :-)

>
> SELECT *
> FROM (SELECT * FROM worksheet_forms ORDER BY id DESC) WorksheetForm
> where company_id = '000002'
> GROUP BY WorksheetForm.generated_id

SELECT
*
FROM
worksheet_forms
WHERE
company_id = '000002'
GROUP BY generated_id
ORDER BY id DESC

Does bring the same rows quantity of your former sql query?...if this
is correct you can translate to cakephp as follows:

$model = getModel('WorksheetForm');
$model->find('all', array(
'conditions' => array(
'company_id' => '000002'
),
'group' => 'generated_id',
'order' => 'id DESC'
)
)

>
> Thanks for any help!

hope that works!

--
Milton

--
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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php