Re: Particular find operation to do

Yes the table is indexed correctly.

The problem is in the length of the query.

On Thursday, 20 December 2012 10:30:46 UTC+1, Jeremy Burns wrote:

Is the table indexed correctly?

Jeremy Burns

Class Outfit

http://www.classoutfit.com

On 20 Dec 2012, at 08:50:19, byqsri <marco.r...@gmail.com> wrote:

If the query is too big you can get this error :

SQL Error: 1153: Got a packet bigger than 'max_allowed_packet' bytes

My query is :

SELECT `User`.`id` FROM `users` AS `User` WHERE `User`.`id` NOT IN (1,2,3,4,5.....

 

I have testing this query on my sql server and I get the previuos error if I have 70000 'id' in NOT IN conditions.

I can't modify max_allowed_packet  in my production server

I think that it isn't the best solutions 

On Wednesday, 19 December 2012 18:21:06 UTC+1, byqsri wrote:

Hi

I'm newbie with cakephp

I have model User, model Group and model UsersGroup ( an user can belongs to many groups and a group can have many users).

I would ask how in CakePHP can I find all users that not belong to the Group group_id (where group_id is a generic int value)

Many thanks

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake...@googlegroups.com.
To unsubscribe from this group, send email to cake-php+u...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
 
 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
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+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.