Hi All, How do I go about generating the following SQL line using cakePHP from the timesheets controller?
SELECT user_id, date, count(id) as count_name FROM `timesheets`GROUP BY user_id, date HAVING count_name > 1 ORDER BY count_name; Basically it is just checking for double up records mathching the date and user_id fields. Thanks -- 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
