Thank you, it looks like that's the stuff I need!
--~--~-~--~~~---~--~~
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
findAll is only for performing a select on all or certain fields with
where clause.
findBySQL is deprecated. Use query instead.
It also looks like query can be cached and execute cannot.
And if you are doing joins then I would SERIOUSLY recommend the
associations.
--~--~-~--~~-
there is a findBySQL method also, which allows you to put in any SQL
you want, wouldn't that work? I think the documentation on this
function is messed up, but it should work.
Also, you can pass any conditions, I think, to the findAll function to,
so I think you could put together joins.
--~-
If you check out the API entry for findAll[1] there are function parameters that should be able to do anything you might want with the queries. As far as doing JOIN queries and the like I would recomend checking out the association features in cake. The best resource I have found to explain that is
ok, so although I'm pretty seasoned with php itself, I'm 100% pure cake
newbie, and this is likely answered somewhere, but I just haven't found
it yet. Not in the manual, not in the wiki, and not here in this group.
This seems to be ripe for an entry in an FAQ somewhere though.
Here's the deal: I