Christophe, You have to follow convention if you want Cake to play with you....
Try this: CREATE VIEW users_profile_view AS SELECT User.id as UserProfileView.id, User.username as UserProfileView.username, DATE( User.last_login ) as "UserProfileView.last_login", User.city as "UserProfileView.city", etc..... If that doesn't work let me know. Usually if you alias everything it should work perfectly. If not, you can use the raw dbo methods for query and retrieval. Peace. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---