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 outs
John David Anderson (_psychic_) wrote:
> You can always use query() and execute() for custom SQL, though I'd
> probably stick to the model functions as often as I could.
>
> -- John
>
Ok, excellent! Thanks very much for the fast answer, John!
Bernard
--~--~-~--~~~--
On Aug 10, 2006, at 10:09 AM, Bernard Grosperrin 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..
You can specify your ORDER BY clauses in find() and findAll() (and
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
--~--~-~
