Chris, thanks for the quick reply, but the problem is not to select only a few fields from 'Post'. I want to select only a few fields from 'Comment Author' like nickname and id. I don't want fields like hash and sault.
Please take a look at the data I receive from the query. I think this should help to understand my problem. Array ( [Post] => Array ( [id] => 14 [title] => TEST title [content] => TEST content [status] => draft [created] => 2007-08-24 23:03:35 [modified] => 2007-08-24 23:09:31 ) [Comment] => Array ( [0] => Array ( [id] => 1 [user_id] => 1 [content] => The first test [created] => 2007-09-04 21:46:23 [modified] => 2007-09-04 21:46:23 [Author] => Array ( [id] => 1 [nickname] => Braindead [hash] => ***this is the hash*** [salt] => ***this is the salt*** [realname] => Markus [description] => Test description [created] => 2007-07-29 00:00:00 [modified] => 2007-08-18 12:15:48 ) ) ) ) Thanks, Markus --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---