Hi AD7six Thanks for your answer.
Yes I've realized my mistake. Off course it's a sql error and I was wrong when I though that this could come from the treeBehavior because as you said : "The tree behavior does not mix max() with other fields" and the other field come from another behavior that add fields. Again thanks you for your answer event if it's not a really interesting error ^^. last thing : I don't understand TreeBehavior isn't appropriate because menus can have many levels and I often read children's node. Do you use a simpler implementation? Quentin. -- 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
