Re: [web2py] Re: Full text search query

2013-04-23 Thread Johann Spies
On 18/04/2013 15:13, Anthony wrote: In your other examples, one or more fields are passed to the .select(), so the DAL has a way to know which table is being queried. When you pass only a string as the query and no fields to .select(), the DAL has no way to know which table is involved (it

[web2py] Re: Full text search query

2013-04-18 Thread Anthony
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

Re: [web2py] Re: Full text search query

2013-04-18 Thread Anthony
In your other examples, one or more fields are passed to the .select(), so the DAL has a way to know which table is being queried. When you pass only a string as the query and no fields to .select(), the DAL has no way to know which table is involved (it does not inspect string queries -- it