Re: Help in simple query!

That would be the expected result for that query. You aren't including the 'SudentAttendance' model in your query. Looking how to use Containable, or custom join. You don't say what kind of relation there is between StudentAttendance and Student. CakePHP can't guess what you are trying to do, you need to tell it (The guessing part is coming up in version 4 as part of the MRD featureset)

On Thursday, 30 May 2013 01:46:53 UTC+2, gonzela2006 wrote:

Hello,

I used the following code in "StudentAttendances" controller:

$students = $this ->StudentAttendance->Student-> find('all', array(

'conditions' => array(

'NOT' => array('StudentAttendance.date' => array($year.'-'.$month.'-'.$day))

),

'fields' => array('Student.id', 'Student.name'),

'order' => 'Student.name ASC'

));

On Wednesday, May 29, 2013 8:02:29 AM UTC+2, resting wrote:

It will be helpful if you show us what you had done to produce that error.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.