Re: Conditions $quoteValues

2009-09-30 Thread seanislegend

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

2009-09-30 Thread seanislegend

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

2009-09-30 Thread John Andersen

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

2009-09-30 Thread seanislegend

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
-~--~~~~--~~--~--~---