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 does

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 jus

Re: [web2py] Re: Full text search query

2013-04-18 Thread Johann Spies
In another app I can do: query = "akb_articles.tsv@@'simple','%'" % request.search_for and then form = SQLFORM.grid(query) or another variation: query = "akb_articles.tsv@@to_tsquery('simple', '%s')" % ss or something like this: l = db("akb_articles.tsv@@'kerkreg | (