I think by this: x = ['a', 'b', 'c', ...] queries.append(db.mytable.myfield.contains(x))
you mean: x = ['a', 'b', 'c', ...] queries.append(db.mytable.myfield.belongs(x)) You cannot pass a list to contains. That may part of the problem. there may be other problems. Can you show more code or explain what the query is supposed to do? Massimo On Saturday, 17 August 2013 21:11:52 UTC-5, dave wrote: > > 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.
