For me, db("rauthor.addressfulltext@@'south & africa'").select() results in "SyntaxError: Set: no tables selected" because the query is a string and no fields were passed to .select().
Anthony On Thursday, April 18, 2013 7:46:42 AM UTC-4, Johann Spies wrote: > > In psql I can do: > > select * from isi.rauthor A > where > A.addressfulltext@@'south & africa' > > > but the following > > l = db("rauthor.addressfulltext@@'south & africa'").select() > > results in > > TypeError: %d format: a number is required, not NoneType > > > Why? > > Model: > > from gluon.dal import SQLCustomType > tsv = SQLCustomType( > type ='text', > native='tsvector' ) > ... > Field('addressfulltext',type=tsv), > > > Regards > Johann > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3) > -- --- 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.