Re: 'too many SQL variables' error with ModelMultipleChoiceField

On Mon, Apr 23, 2012 at 3:58 AM, akaariai <akaariai@gmail.com> wrote:
> The last one, qs.filter(id__in=large_list) is pretty much impossible to fix.

what's wrong with:

qs.filter((Q(id__in=large_list[:n])|Q(id__in=large_list[n:]))) ?

>   1. Use different database. I guess you have a reason to use SQLite so this
> might not be an option.

Oracle has a 1000-element limit for the IN (....) clause. Of course,
it does work with (IN(<1sthalf>) or IN(<2ndhalf>))

--
Javier

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.