Re: How to accomplish SELECT [not *] and WHERE clause?

2006-05-05 Thread calzone
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

Re: How to accomplish SELECT [not *] and WHERE clause?

2006-05-05 Thread [EMAIL PROTECTED]
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. --~--~-~--~~-

Re: How to accomplish SELECT [not *] and WHERE clause?

2006-05-04 Thread [EMAIL PROTECTED]
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. --~-

Re: How to accomplish SELECT [not *] and WHERE clause?

2006-05-04 Thread BoBB
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

How to accomplish SELECT [not *] and WHERE clause?

2006-05-04 Thread calzone
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