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 just completed the blog tutorial and it occurred to me that this is all very nice but... the findAll() method seems to simply return every single column and every single row from the database, while, the read() method seems to be just for the purposes of returning all columns for one record. This seems horribly inefficient. I'm positive there must be a way to refine these queries somehow under cake and I'm just bumbling in the dark. I'd like to be able to only grab a certain number of columns, or perhaps a count of records or a sum of records. I'd like to be able to ask the database to return only records that match a certain criteria, or only to update records matching a certain criteria. Also, I'd like to be able to create inner and outer joins across several tables and even databases if need be. I'm sorry, but I just don't get how to use cake for all of that. I'm currently trying to set about rewriting some of my existing websites under cake, and there is all sorts of database logic going on. I'm guessing there's probably a lot of built in methods that handle a lot of this stuff, as well as possibly a method to pass a custom query? Yes? No? Any help or direction is much appreciated! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
