I think if I understand correctly, you might be able to find what you want here:
http://manual.cakephp.org/chapter/models basically there are a few different ways of retrieving your data - find, findAll, query, etc. find and findAll have scope for order by and limit and such, then anything outside of that you could simply use query. there are also other methods which i am now only learning where you can set the `findQuery` variable when relating one model to another by an association. i'm still learning that one though so i will leave it to you to explore more. apologies if i've missed the mark. On 11/08/06, Bernard Grosperrin <[EMAIL PROTECTED]> wrote: > > Very new, trying to learn and understand. > > What is the proper way to have my own SQL Statements? For example, if I > want to add "ORDER BY", or "GROUP BY", etc.. > Have been trying to search for "Custom SQL", but have not found what I > was looking for. > > Thanks for any hint, > Bernard > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---