Jeff, That's been my experience, too, when using database views in Cake: unless I alias everything very deliberately, all the naming becomes too confusing and it's basically impossible for me to keep the columns straight and make things work properly.
Nevertheless, I didn't know one could write something like "AS UserProfileView.id" -- I was just writing "AS id" in that case, and everything appeared to work. Is there a reason to do it one way or another? It seems that Cake translates the lower-case-and-underscore names into camelCase names for use in the arrays, anyway. To be perfectly honest, I sometimes find this SQL stuff a bit disorienting, both to set up and to discuss. SQL seems to be in another slightly ghostly world from our everyday programming languages. And Bernard, I actually enjoy admitting that I don't understand everything. That gives me a chance to learn something new. Learning is one of the greatest pleasures in my life, and I would feel deprived without it. As a result, I have a powerful and continuing need for significant quantities of my own ignorance. Fortunately, I haven't come close to running out yet. Regards, Ralph On Jan 29, 10:38 am, "Jeff Loiselle aka phishy" <[EMAIL PROTECTED]> wrote: > Usually if you alias everything it > should work perfectly. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
