On Thursday, November 3, 2022 at 8:57:23 AM UTC-7 vincent...@gmail.com wrote:
> Hello, > > I have a simple SQLFORM.grid that shows the rows of my simple SQLite > database. > In the grid, when I click on, say, the "vendorname" column header, this > performs a kind of alphabetical sort, but the sort is case sensitive, so > for example "AXE" comes before "Abc". How can I make the grid achieve a > case insensitive sort? > > Thanks > You have to write the query to be case insensitive, as none of the other grid parameters are helpful. /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/c6bd4073-f902-4518-8ac3-05612cdcd6e2n%40googlegroups.com.
