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 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 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 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 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 . ""; >> > > $order = >> > > $this->GallerysImage->find("parent_id = " . $this->data >> > > ['GallerysImage']['parent_id'], "order", "order DESC"); >> > > //$this->data['GallerysImage']['order'] >> > > = $order['GallerysImage'] >> > > ['order'] + 1; >> > > echo $i . ""; >> > > $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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Weird - not executing query in every foreach iteration
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 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 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 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 . ""; > > > $order = > > > $this->GallerysImage->find("parent_id = " . $this->data > > > ['GallerysImage']['parent_id'], "order", "order DESC"); > > > //$this->data['GallerysImage']['order'] = > > > $order['GallerysImage'] > > > ['order'] + 1; > > > echo $i . ""; > > > $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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Weird - not executing query in every foreach iteration
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 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 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 . ""; > > $order = > > $this->GallerysImage->find("parent_id = " . $this->data > > ['GallerysImage']['parent_id'], "order", "order DESC"); > > //$this->data['GallerysImage']['order'] = > > $order['GallerysImage'] > > ['order'] + 1; > > echo $i . ""; > > $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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Weird - not executing query in every foreach iteration
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 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 . ""; > $order = > $this->GallerysImage->find("parent_id = " . $this->data > ['GallerysImage']['parent_id'], "order", "order DESC"); > //$this->data['GallerysImage']['order'] = > $order['GallerysImage'] > ['order'] + 1; > echo $i . ""; > $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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---