>From glancing at the code (1.2), it seems that model::query() can do more than just take a string argument. Is there anywhere that has details as to the possible syntax for the query() function, or should I wade through the code and figure it out? :)
I'm using it because I need to pull all the possible values for a single field in a table, and I'd rather not do a findAll, then go through each record and make my own list of possible values. Instead, I'd like to just do a select distinct -- but there is a possibility the table name may change in future applications, so I'd like to keep the query compatible with Cake's other tenants. The query: select distinct academic_year from faculty The return: All possible years in the table --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---