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 boredofm...@googlemail.com 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 boredofm...@googlemail.com 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 boredofm...@googlemail.com 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 boredofm...@googlemail.com wrote: OK, that actually doesn't work by the looks of it :( On Sep 30, 1:00 pm, seanislegend boredofm...@googlemail.com 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 boredofm...@googlemail.com 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
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 j.andersen...@gmail.com 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 boredofm...@googlemail.com wrote: OK, that actually doesn't work by the looks of it :( On Sep 30, 1:00 pm, seanislegend boredofm...@googlemail.com 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 boredofm...@googlemail.com 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 -~--~~~~--~~--~--~---