Jeff Loiselle > 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. > Good advice, thanks, will try. Bernard
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
