I wonder if some kind of model extension could be proposed by people who are deeply involved in the use of views in their database environments, one that could create a mapping from what a view returns to what it would equate to in cakephp constructed style model queries. That could then be used to create the CakePHP style of results
On 1/29/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > 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. > > > > > -- == S. DeVore (the old fart) the advice is free, the lack of crankiness will cost you - its a fine line between a real question and an idiot --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
