Massimo, I was like what are you talking about ? , then I noticed you actually asking to input whole thing between " and "...
Yeah, it works !! but I cannot ask my users to do. Like Niphlod said, option flag to switch the search method will be great. On Sep 30, 5:29 pm, Massimo Di Pierro <[email protected]> wrote: > type in the search field "part_number starts with ab" > > On Sep 27, 6:20 pm, Omi Chiba <[email protected]> wrote: > > > > > > > > > For example, I have a field which has 'abcab' and 'bcabc' data. > > If I provide 'ab' in the search box, I want to just pull the first one > > ('abcab') and exclude second one ('bcabc'). Can we do this ? > > > models/db.py > > --------------------- > > db.define_table('Product', > > Field('Part_Number')) > > > controllers/default.py > > ------------------------------ > > def admin(): > > products = SQLFORM.grid(db.Product,deletable=False, paginate=10) > > return dict(products = products)

