I guess nobody encountered this issue before?

On Thursday, August 15, 2013 11:59:31 AM UTC-7, dave wrote:
>
> .
> .
> .
> x = ['a', 'b', 'c', ...]
> queries.append(db.mytable.myfield.contains(x))
> query = reduce(lambda a,b:(a&b),queries)
> grid = SQLFORM.grid(query, ...)
>
> return (grid=grid)
>
> gives an error of "Query Not Supported: parser stack overflow", if the 
> list x has too many values, like around 100 or a 1000, I suspect its an 
> sqlite limitation? can anyone suggest another succinct way of passing a 
> list to a contain like operator or method. 
>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to