Re: Weird - not executing query in every foreach iteration

$order = $this->GallerysImage->find("parent_id = " .
$this->data['GallerysImage']['parent_id'], "order", "order DESC");

Why are you trying to run this query in a loop, anyway? It will always
be the same. Did you instead want to use something from the $file var?

On Wed, Jun 24, 2009 at 4:52 PM, Sanfly<sanfly@gmail.com> wrote:
>
> Sweet, figured it out!
>
> Apparently cake caches queries unless you tell it not to:
>
> $this->GallerysImage->cacheQueries = false;
>
>
> Onward!!
>
> :)
>
> On Jun 25, 7:18 am, Sanfly <san...@gmail.com> wrote:
>> I dont know what the heck is going on with this thread, why does it
>> keep getting hijacked?
>>
>> Runckel,  thanks I had already tried that though and no luck
>>
>> Anyone else?
>>
>> Cheers
>>
>> On Jun 24, 9:58 pm, runckel <robhueb...@web.de> wrote:
>>
>> > Try to make a $this->GallerysImage->create() after the query, i had
>> > this problem with a save condition and the create solved it.
>>
>> > On 24 Jun., 10:27, Sanfly <san...@gmail.com> wrote:
>>
>> > > Hi Guys
>>
>> > > I have a foreach loop, and in this foreach loop is a "query".  I need
>> > > this query to be re-queried in every iteration of the loop as it
>> > > changes each time.  However, no matter what I do it will only do the
>> > > query once
>>
>> > > Ive stripped a bunch of stuff out to try and diagnose what is going
>> > > on, but I just dont get it!  Can anyone fill me in on what could be
>> > > going on?  And yes, there are at least two values in the array.
>>
>> > > The Loop:
>>
>> > > $i = 1;
>> > >                         foreach($uploadFiles as $file){
>> > >                                 //$this->GallerysImage->create();
>>
>> > >                                 // Order
>> > >                                 echo $i . "<br>";
>> > >                                 $order = $this->GallerysImage->find("parent_id = " . $this->data
>> > > ['GallerysImage']['parent_id'], "order", "order DESC");
>> > >                                 //$this->data['GallerysImage']['order'] = $order['GallerysImage']
>> > > ['order'] + 1;
>> > >                                 echo $i . "<br>";
>> > >                                 $i++;
>>
>> > >                                 // other stuff goes here
>> > >                         }
>>
>> > > The Result:
>> > > 1
>> > > 1
>> > > 2
>> > > 2
>>
>> > > And in the debug it only comes up once :
>>
>> > > 25      SELECT `GallerysImage`.`order` FROM `gallerys_images` AS
>> > > `GallerysImage` LEFT JOIN `members` AS `Member` ON
>> > > (`GallerysImage`.`member_id` = `Member`.`id`) WHERE parent_id = 7
>> > > ORDER BY `order` DESC LIMIT 1           1       1       0
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---