Help in simple query!

Hello,

As you can see on the below image

I want to display students that didn't attendance on date 2013-03-01 so the result should be as the following:

id name

2 Marta Simon

4 Rex Maxwell

6 Vivian Ellis

I know this is simple query but I got this error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'StudentAttendance.date' in 'where clause'

Thanks,

--
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.