Hi LipeDjow I'm not sure your solution will work for me, I am writing the query in my model like this:
http://pastie.org/private/q4v8ypn5v8xq7crfbqcha "MessageStatus" is the model that I originally had as an ArraySource. I had to change it to run from a MySQL table. 1. Unread 2. Read 3. Deleted What I was trying to accomplish was to fetch all messages where the "MessageRecipient" didn't have a "message_status_id" of 3, as well as fetching the MessageStatus.name field to present in the view. This is too small to warrant any headaches, but I am concerned in the sense that, when I start creating "search" or "browse" features with my other ArraySource models - I will need to change them in to regular tables? It isn't the end of the world, but the ArraySource method is nice. -- Kind Regards Stephen @ NinjaCoderMonkey www.ninjacodermonkey.co.uk -- 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
