Re: Conditions $quoteValues
Thanks VERY much for your reply, John. $releases_ids was actually a string so all I had to do was replace 'array($release_ids)' with 'explode(",", $release_ids)'. Again, thanks for the tip! Cheers On Sep 30, 1:38 pm, John Andersen wrote: > Ok, if I remember correctly, then you just need to change: > > 'Release.id' => array($release_ids) > > into > > 'Release.id' => $release_ids > > as $release_id is already an array! > Enjoy, > John > > On Sep 30, 3:14 pm, seanislegend wrote: > > > OK, that actually doesn't work by the looks of it :( > > > On Sep 30, 1:00 pm, seanislegend wrote: > > > > Nevermind, got it! > > > > All you need to do is simply put your conditions outside of the find > > > array in $this->conditions. > > > > Ch33rz! > > > > On Sep 30, 12:56 pm, seanislegend wrote: > > > > > Hi, > > > > > I'm trying to disable $quoteValues (http://api.cakephp.org/view_source/ > > > > dbo-source/#line-1745), but I cannot get it working at all. > > > > > My finder query looks like this (trimmed down): > > > > > $this->find('all', array( > > > > 'conditions' => array( > > > > 'Release.id' => array($release_ids) > > > > ) > > > > )); > > > > > $release_ids is a string of ids, such as: '1,2,3,4,5'. > > > > > The resulting conditions is: "WHERE `Release`.`id` = ('1,2,3,4,5')", > > > > and what I need is: "WHERE `Release`.`id` IN (1,2,3,4,5)" > > > > > Can anyone help, please? > > > > Cheers! --~--~-~--~~~---~--~~ 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: Conditions $quoteValues
Ok, if I remember correctly, then you just need to change: 'Release.id' => array($release_ids) into 'Release.id' => $release_ids as $release_id is already an array! Enjoy, John On Sep 30, 3:14 pm, seanislegend wrote: > OK, that actually doesn't work by the looks of it :( > > On Sep 30, 1:00 pm, seanislegend wrote: > > > Nevermind, got it! > > > All you need to do is simply put your conditions outside of the find > > array in $this->conditions. > > > Ch33rz! > > > On Sep 30, 12:56 pm, seanislegend wrote: > > > > Hi, > > > > I'm trying to disable $quoteValues (http://api.cakephp.org/view_source/ > > > dbo-source/#line-1745), but I cannot get it working at all. > > > > My finder query looks like this (trimmed down): > > > > $this->find('all', array( > > > 'conditions' => array( > > > 'Release.id' => array($release_ids) > > > ) > > > )); > > > > $release_ids is a string of ids, such as: '1,2,3,4,5'. > > > > The resulting conditions is: "WHERE `Release`.`id` = ('1,2,3,4,5')", > > > and what I need is: "WHERE `Release`.`id` IN (1,2,3,4,5)" > > > > Can anyone help, please? > > > Cheers! --~--~-~--~~~---~--~~ 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: Conditions $quoteValues
OK, that actually doesn't work by the looks of it :( On Sep 30, 1:00 pm, seanislegend wrote: > Nevermind, got it! > > All you need to do is simply put your conditions outside of the find > array in $this->conditions. > > Ch33rz! > > On Sep 30, 12:56 pm, seanislegend wrote: > > > Hi, > > > I'm trying to disable $quoteValues (http://api.cakephp.org/view_source/ > > dbo-source/#line-1745), but I cannot get it working at all. > > > My finder query looks like this (trimmed down): > > > $this->find('all', array( > > 'conditions' => array( > > 'Release.id' => array($release_ids) > > ) > > )); > > > $release_ids is a string of ids, such as: '1,2,3,4,5'. > > > The resulting conditions is: "WHERE `Release`.`id` = ('1,2,3,4,5')", > > and what I need is: "WHERE `Release`.`id` IN (1,2,3,4,5)" > > > Can anyone help, please? > > Cheers! --~--~-~--~~~---~--~~ 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: Conditions $quoteValues
Nevermind, got it! All you need to do is simply put your conditions outside of the find array in $this->conditions. Ch33rz! On Sep 30, 12:56 pm, seanislegend wrote: > Hi, > > I'm trying to disable $quoteValues (http://api.cakephp.org/view_source/ > dbo-source/#line-1745), but I cannot get it working at all. > > My finder query looks like this (trimmed down): > > $this->find('all', array( > 'conditions' => array( > 'Release.id' => array($release_ids) > ) > )); > > $release_ids is a string of ids, such as: '1,2,3,4,5'. > > The resulting conditions is: "WHERE `Release`.`id` = ('1,2,3,4,5')", > and what I need is: "WHERE `Release`.`id` IN (1,2,3,4,5)" > > Can anyone help, please? > Cheers! --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---