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 [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en.
