| # |
Aug 9th 2008, 14:54 |
AD7six |
barduck: doesn't find('first', array('fields' => 'COUNT(DISTINCT....) AS count' ..? |
| # |
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 |
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: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:51 |
TheBig |
you should do Post->find('count', by user) |
| # |
Aug 9th 2008, 14:50 |
TheBig |
instead of doing User->find('count', bla bla posts) |
| # |
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:49 |
barduck |
TheBig: what do you mean ? |
| # |
Aug 9th 2008, 14:49 |
TheBig |
barduck, why don you make a find('count') of that model? |
| # |
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:48 |
barduck |
hey, how can I tell find('count') to count DISTINCT Model.* instead of * ? |
| # |
Aug 9th 2008, 14:48 |
jaredhoyt |
i've never used it |
| # |
Aug 9th 2008, 14:48 |
jaredhoyt |
is SecurityComponent::disabledFields like the opposite of the $whiteList in save()? |
| # |
Aug 9th 2008, 14:43 |
DrBacchus |
Glad to help in what small ways I can. |
| # |
Aug 9th 2008, 14:43 |
DrBacchus |
Better now? |
| # |
Aug 9th 2008, 14:40 |
klaasjan |
man you are a legend |
| # |
Aug 9th 2008, 14:38 |
klaasjan |
i 'll try |
| # |
Aug 9th 2008, 14:34 |
DrBacchus |
Now your .htaccess files should work fine. |
| # |
Aug 9th 2008, 14:34 |
klaasjan |
Ok i'v changed that to all |
| # |
Aug 9th 2008, 14:34 |
DrBacchus |
AllowOverride is set per directory. |
| # |
Aug 9th 2008, 14:34 |
DrBacchus |
And then inside that block, you'll see another AllowOverride directive |
| # |
Aug 9th 2008, 14:34 |
DrBacchus |
so you should see <Directory "C:/Program Files/php/apache2/htdocs"> |
| # |
Aug 9th 2008, 14:33 |
DrBacchus |
ok good |
| # |
Aug 9th 2008, 14:33 |
klaasjan |
i guess |
| # |
Aug 9th 2008, 14:33 |
klaasjan |
C:/Program Files/php/apache2/htdocs"> |
| # |
Aug 9th 2008, 14:33 |
markstory |
Anon323: its controller wide. |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
What directory contains your cake files? |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
It'll refer to your document root. |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
You'll see <Directory /var/www/html> or something like that |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
ok |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
Then look a little further down in the configuration file. |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
klaasjan: Change that back to allowoverride none. |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
Deny from |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
klaasjan: Ok, that's the wrong place. |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
Order deny,allow |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
AllowOverride All |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
Options FollowSymLinks |
| # |
Aug 9th 2008, 14:32 |
DrBacchus |
So it's not technically incorrect, but should mention that AddModule dosn't exist in 2.x |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
Header append Vary User-Agent |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
AddOutputFilterByType DEFLATE text/html text/plain text/css |
| # |
Aug 9th 2008, 14:32 |
klaasjan |
<Directory /> |