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.