Yes thanks for this, it is powerful if you know how, but I am building a website for other users. suppose a user types in the search box
cormac maccarthy it would be nice if it did a search on all fields and found records that contained both cormac and mccarthy. Maybe it would have to be "cormac maccarthy". I'm not sure but the simpler the better. One can give the user only very simple instructions. Peter On Feb 4, 10:27 am, Michele Comitini <[email protected]> wrote: > Suppose you have a table: > > db.define_table('book', Field('author', 'string'), Field('title', > 'string'), Filed('description', 'text')) > > you can search like this: > > author is "cormac mccarthy" and title contains "horses" > > mic > > 2012/2/4 peter <[email protected]>: > > > > > > > > > SQLFORM.grid's search box seems to only work with single word search > > terms. Has anyone looked into it working with multiple words, working > > as if they are 'and'ed together?
