Page 371 of 211,269, showing 20 records out of 4,225,379 total, starting on record 7,401, ending on 7,420
| # | Username | Text | |
|---|---|---|---|
| # | Aug 9th 2008, 14:48 | jaredhoyt | is SecurityComponent::disabledFields like the opposite of the $whiteList in save()? |
| # | Aug 9th 2008, 14:48 | jaredhoyt | i've never used it |
| # | Aug 9th 2008, 14:48 | barduck | hey, how can I tell find('count') to count DISTINCT Model.* instead of * ? |
| # | Aug 9th 2008, 14:49 | jaredhoyt | except i'd imagine it wouldn't even let the fields pass into $this->data |
| # | Aug 9th 2008, 14:49 | TheBig | barduck, why don you make a find('count') of that model? |
| # | Aug 9th 2008, 14:49 | barduck | TheBig: what do you mean ? |
| # | Aug 9th 2008, 14:50 | TheBig | it hangs on what you need, but let's say you need post of a user |
| # | Aug 9th 2008, 14:50 | TheBig | instead of doing User->find('count', bla bla posts) |
| # | Aug 9th 2008, 14:51 | TheBig | you should do Post->find('count', by user) |
| # | Aug 9th 2008, 14:52 | barduck | TheBig: not sure what you mind but I have a query with some complicated joins in it and in order to get the result I need, I need to use DISTINCT on the main model. That works well in the find('all') model but I also need a total count of these items (for pagination) |
| # | Aug 9th 2008, 14:54 | barduck | I guess I can just do a find('all', 'COUNT(...)') myself but I thought there might be a more elegant way |
| # | Aug 9th 2008, 14:54 | jaredhoyt | hmm, my beforeSave() doesn't seem to be working correctly ... i'm formating some fields before saving and i've done a pr($this->data) just to make sure it's coming out correctly (which it is) ... they're just not showing up in the db |
| # | Aug 9th 2008, 14:54 | AD7six | barduck: doesn't find('first', array('fields' => 'COUNT(DISTINCT....) AS count' ..? |
| # | Aug 9th 2008, 14:54 | jaredhoyt | the rest of the data is, just not these two particular fields i'm changing |
| # | Aug 9th 2008, 14:55 | jaredhoyt | http://bin.cakephp.org/view/1205572484 |
| # | Aug 9th 2008, 14:55 | barduck | AD7Six: yes, that would work, of course. I thought there might be some parameter that I can just pass to find('count') to make it cleaner |
| # | Aug 9th 2008, 14:55 | jaredhoyt | i did a pr($this->data) right before the return true; and the 'mailing_address' and 'country' fields are present and contain the correct values... they're just not ending up in the db |
| # | Aug 9th 2008, 14:56 | barduck | AD7six: that once was fixed for findCount -> https://trac.cakephp.org/ticket/2445 |
| # | Aug 9th 2008, 14:56 | barduck | althought I never used it since |
| # | Aug 9th 2008, 14:56 | jaredhoyt | 'mailing_address' is tinytext and 'country' is varchar |