Re: How to use not in in new find() ?

2008-04-24 Thread rob30
ups sorry it works as expected, thanks ! --~--~-~--~~~---~--~~ 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

Re: How to use not in in new find() ?

2008-04-23 Thread rob30
I've tried 'conditions' = array('not' = array('id' = $model_ids; but its not ok :( it generates: WHERE NOT ((`id` IN (2, 5) )) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this

Re: How to use not in in new find() ?

2008-04-23 Thread Chris Hartjes
On Wed, Apr 23, 2008 at 3:44 AM, rob30 [EMAIL PROTECTED] wrote: I've tried 'conditions' = array('not' = array('id' = $model_ids; but its not ok :( it generates: WHERE NOT ((`id` IN (2, 5) )) Of course it works. Let's say I have a table called 'teams'. ibl_stats=# select count(*)

How to use not in in new find() ?

2008-04-22 Thread rob30
Hi, How to use not in in new find() syntax? in is working fine $this-Model-find('list', array('fields' = array('id', 'name'), 'conditions' = array('id' = $model_ids))); generates: SELECT `Model`.`id`, Model`.`name` FROM `models` AS `Model` WHERE `id` IN (2, 5) but how to generate WHERE `id

Re: How to use not in in new find() ?

2008-04-22 Thread grigri
Try: $this-Model-find('list', array('fields' = array('id', 'name'), 'conditions' = array('not' = array('id' = $model_ids; --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group,