Bernard, Views work in my Oracle driver. Not sure about the other drivers. I don't see why they shouldn't work, they act just like tables. Be warned that you have to be explicitly clear in aliasing your complex queries, or Cake will not know what to do.
SELECT User.first_name, User.last_name FROM users User If you're using SQL functions, don't forget to alias those as well... The aliases are the foundation to RDBMS -> ORM mapping in this implementation.. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
