Re: 'too many SQL variables' error with ModelMultipleChoiceField

2012-04-23 Thread Lukas Zilka
to > select a lot more options, then you might need to use a more exotic widget > that avoids the need to transfer full lists back and forth. > > Yours, > Russ Magee %-) > > > > > > > > On Monday, 23 April 2012 at 5:38 AM, Lukas Zilka wrote: > > Hello, > > >

Re: 'too many SQL variables' error with ModelMultipleChoiceField

2012-04-23 Thread Lukas Zilka
Thanks for your reply Anssi. My previous post probably got lost somewhere (or maybe just awaiting moderation?), so I am going to repeat the relevant part. It is related with your point on qs.filter(id__in=large_list), so I will try to say it again. Why do you use SQL variables when you construc

'too many SQL variables' error with ModelMultipleChoiceField

2012-04-22 Thread Lukas Zilka
Hello, I have a form with ModelMultipleChoiceField on it, and I am getting 'DatabaseError: too many SQL variables' (using SQLite) when the user picks more than 1000 entries in the selection widget and posts the form. The problem seems to be the method clean of ModelMultipleChoiceField, which trie