Help doing this in CakePHP
The group you are posting to is a
Usenet group . Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
From:
Chad Casselman <ccassel... @gmail.com> Date: Mon, 2 Nov 2009 18:29:25 -0500
Local: Tues, Nov 3 2009 10:29 am
Subject: Help doing this in CakePHP
I have a table that looks like:
id created modified domain_id pages search_engine_id
I have spent over half the day trying to figure out how to pull the
Can anyone help me figure out how to do this within CakePHP?
I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Pablo Viojo <pvi... @gmail.com> Date: Mon, 2 Nov 2009 20:36:27 -0300
Local: Tues, Nov 3 2009 10:36 am
Subject: Re: Help doing this in CakePHP
SELECT domain_id, search_engine_id, MAX(id) FROM table GROUP BY domain_id,
Regards,
Pablo Viojo
... @gmail.com
http://pviojo.net
¿Que necesitas?
http://needish.com
On Mon, Nov 2, 2009 at 8:29 PM, Chad Casselman <ccassel
... @gmail.com> wrote:
> I have a table that looks like:
> id created modified domain_id pages
> I have spent over half the day trying to figure out how to pull the
> Can anyone help me figure out how to do this within CakePHP?
> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Chad Casselman <ccassel... @gmail.com> Date: Mon, 2 Nov 2009 18:49:35 -0500
Local: Tues, Nov 3 2009 10:49 am
Subject: Re: Help doing this in CakePHP
Is there anyway to get all the row information with all those ids or
does it require another query to get row details for returned ids?
Thanks,
On Mon, Nov 2, 2009 at 6:36 PM, Pablo Viojo <pvi
... @gmail.com> wrote:
> Something like this may help:
> SELECT domain_id, search_engine_id, MAX(id) FROM table GROUP BY domain_id,
> search_engine_id
> Regards,
> Pablo Viojo
... @gmail.com
http://pviojo.net
> ¿Que necesitas?
http://needish.com
> On Mon, Nov 2, 2009 at 8:29 PM, Chad Casselman <ccassel... @gmail.com> wrote:
>> I have a table that looks like:
>> id created modified domain_id pages
>> I have spent over half the day trying to figure out how to pull the
>> Can anyone help me figure out how to do this within CakePHP?
>> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Pablo Viojo <pvi... @gmail.com> Date: Mon, 2 Nov 2009 21:11:22 -0300
Local: Tues, Nov 3 2009 11:11 am
Subject: Re: Help doing this in CakePHP
I recommend to do two queries instead.
Regards,
Pablo Viojo
... @gmail.com
http://pviojo.net
¿Que necesitas?
http://needish.com
On Mon, Nov 2, 2009 at 8:49 PM, Chad Casselman <ccassel
... @gmail.com> wrote:
> Is there anyway to get all the row information with all those ids or
> Thanks,
> On Mon, Nov 2, 2009 at 6:36 PM, Pablo Viojo <pvi... @gmail.com> wrote:
> > Pablo Viojo
... @gmail.com
http://pviojo.net
> > ¿Que necesitas?
http://needish.com
> > On Mon, Nov 2, 2009 at 8:29 PM, Chad Casselman <ccassel... @gmail.com>
> >> I have a table that looks like:
> >> id created modified domain_id pages
> >> I have spent over half the day trying to figure out how to pull the
> >> Can anyone help me figure out how to do this within CakePHP?
> >> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Chad Casselman <ccassel... @gmail.com> Date: Mon, 2 Nov 2009 19:41:52 -0500
Local: Tues, Nov 3 2009 11:41 am
Subject: Re: Help doing this in CakePHP
Any idea how to use this approach with pagination?
Chad
On Mon, Nov 2, 2009 at 7:11 PM, Pablo Viojo <pvi
... @gmail.com> wrote:
> You can do something using subqueries (but if you're quering the same table
> on main and sub query, it will not perform well)
> I recommend to do two queries instead.
> Regards,
> Pablo Viojo
... @gmail.com
http://pviojo.net
> ¿Que necesitas?
http://needish.com
> On Mon, Nov 2, 2009 at 8:49 PM, Chad Casselman <ccassel... @gmail.com> wrote:
>> Is there anyway to get all the row information with all those ids or
>> Thanks,
>> On Mon, Nov 2, 2009 at 6:36 PM, Pablo Viojo <pvi... @gmail.com> wrote:
>> > Pablo Viojo
... @gmail.com
http://pviojo.net
>> > ¿Que necesitas?
http://needish.com
>> > On Mon, Nov 2, 2009 at 8:29 PM, Chad Casselman <ccassel... @gmail.com>
>> >> I have a table that looks like:
>> >> id created modified domain_id pages
>> >> I have spent over half the day trying to figure out how to pull the
>> >> Can anyone help me figure out how to do this within CakePHP?
>> >> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
schneimi <michael.schne... @arcor.de> Date: Tue, 3 Nov 2009 02:44:50 -0800 (PST)
Local: Tues, Nov 3 2009 9:44 pm
Subject: Re: Help doing this in CakePHP
Hi,
if I understood you right, this could be what you need:
$result = $this->YourModel->find('all', array('group' => array
With pagination it should look like this:
$this->paginate['YourModel'] = array('group' => array(domain_'id',
In both cases you can get related data with the 'contain' option in
Hope this helps,
Michael
On 3 Nov., 00:29, Chad Casselman <ccassel... @gmail.com> wrote:
> I have a table that looks like:
> id created modified domain_id pages search_engine_id
> I have spent over half the day trying to figure out how to pull the
> Can anyone help me figure out how to do this within CakePHP?
> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
Chad Casselman <ccassel... @gmail.com> Date: Wed, 4 Nov 2009 14:00:28 -0500
Local: Thurs, Nov 5 2009 6:00 am
Subject: Re: Help doing this in CakePHP
Just to clarify, neither of the above works do to the fact the group
happens before the MAX, so MAX does not always return the max value,
normally the first.
Would still like to find a way to pull the latest row for set of data.
Chad
On Tue, Nov 3, 2009 at 5:44 AM, schneimi <michael.schne
... @arcor.de> wrote:
> Hi,
> if I understood you right, this could be what you need:
> $result = $this->YourModel->find('all', array('group' => array
> With pagination it should look like this:
> $this->paginate['YourModel'] = array('group' => array(domain_'id',
> In both cases you can get related data with the 'contain' option in
> Hope this helps,
> Michael
> On 3 Nov., 00:29, Chad Casselman <ccassel... @gmail.com> wrote:
>> id created modified domain_id pages search_engine_id
>> I have spent over half the day trying to figure out how to pull the
>> Can anyone help me figure out how to do this within CakePHP?
>> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
From:
"itc-media.com" <xmlst... @gmail.com> Date: Thu, 5 Nov 2009 00:23:03 -0800 (PST)
Local: Thurs, Nov 5 2009 7:23 pm
Subject: Re: Help doing this in CakePHP
how about using UNION ?
SELECT domain_id, search_engine_id, created, modified, MAX(id) FROM
Regards,
On Nov 4, 8:00 pm, Chad Casselman <ccassel... @gmail.com> wrote:
> Just to clarify, neither of the above works do to the fact the group
> happens before the MAX, so MAX does not always return the max value,
> normally the first.
> Would still like to find a way to pull the latest row for set of data.
> Chad
> On Tue, Nov 3, 2009 at 5:44 AM, schneimi <michael.schne... @arcor.de> wrote:
> > Hi,
> > if I understood you right, this could be what you need:
> > $result = $this->YourModel->find('all', array('group' => array
> > With pagination it should look like this:
> > $this->paginate['YourModel'] = array('group' => array(domain_'id',
> > In both cases you can get related data with the 'contain' option in
> > Hope this helps,
> > Michael
> > On 3 Nov., 00:29, Chad Casselman <ccassel... @gmail.com> wrote:
> >> id created modified domain_id pages search_engine_id
> >> I have spent over half the day trying to figure out how to pull the
> >> Can anyone help me figure out how to do this within CakePHP?
> >> I really appreciate your time.
You must
Sign in before you can post messages.
You do not have the permission required to post.
|
