Alan was referring to the placement of the ~ operator -- it prepends the Query, not the Set. You probably submitted the following to the grid, right?
SQLFORM.grid(~db.log.severity.belongs((1, 2)), ...) Anthony On Friday, April 12, 2013 9:51:38 AM UTC-4, Tito Garrido wrote: > > It works here... at least for a SQLFORM.grid > > > On Thu, Apr 11, 2013 at 10:26 PM, Alan Etkin <spam...@gmail.com<javascript:> > > wrote: > >> Is that the correct syntax? >> >> select() returns a Rows object, and I'm not sure that operation is >> supported, I tried it in a shell and it throws: >> >> TypeError: bad operand type for unary ~: 'Rows' >> >> This instead returns the complement of the record set: >> >> >> >>> db(~db.log.severity.belongs((**1, 2))).select() >> >> >> I suppose it's a mistyped command. >> >> -- >> >> --- >> 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+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > > Linux User #387870 > .........____ > .... _/_õ|__| > ..º[ .-.___.-._| . . . . > .__( o)__( o).:_______ > -- --- 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.
