[web2py] Re: SQLFORM.grid: Search only startswith

2011-09-30 Thread Omi Chiba
And, actually it gives me error ticket if try "model_id starts with 7" this for another field which is int not string. Traceback (most recent call last): File "C:\web2py\gluon\restricted.py", line 194, in restricted exec ccode in environment File "C:/web2py/applications/pricelist/controlle

[web2py] Re: SQLFORM.grid: Search only startswith

2011-09-30 Thread Omi Chiba
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 wrote

[web2py] Re: SQLFORM.grid: Search only startswith

2011-09-30 Thread Massimo Di Pierro
type in the search field "part_number starts with ab" On Sep 27, 6:20 pm, Omi Chiba 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 ? > >

[web2py] Re: SQLFORM.grid: Search only startswith

2011-09-30 Thread Omi Chiba
Niphlod, Thank you finding the source... yeah it's beyond my knowledge. On Sep 30, 1:55 pm, Niphlod wrote: > http://code.google.com/p/web2py/source/browse/gluon/sqlhtml.py#1527 > > maybe a patch with "search_startswith" parameter will improve current > search functionality, in case it is useful

[web2py] Re: SQLFORM.grid: Search only startswith

2011-09-30 Thread Niphlod
http://code.google.com/p/web2py/source/browse/gluon/sqlhtml.py#1527 maybe a patch with "search_startswith" parameter will improve current search functionality, in case it is useful to someone else. On Sep 29, 3:32 pm, Omi Chiba wrote: > Does anybody know where is the code so I can try customize

[web2py] Re: SQLFORM.grid: Search only startswith

2011-09-29 Thread Omi Chiba
Does anybody know where is the code so I can try customize it ? On Sep 27, 6:20 pm, Omi Chiba 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 t