jeff's blog
Digging into Mobile Website Development
Looking into building out a mobile web experience. According to our Google Analytics stripped down mobile browsers outnumber smartphone browsers 6-to-1. Not surprising.
The NetFront Browser, typically found on Samsung phones, accounts for about 40% of our traffic. As such, I think this is the browser for which I want to optimize.
Resources:
Documentation – Designing Web Content for NetFront Browser
MobiForge.com – A Guide to Mobile Emulators
Access – ALP Development Suite for VMWare
Case Insensitive Sort with SQLObject
The key to case-insensitive search is to sort by the lowercase or uppercase of the sorting column.
SELECT * FROM songs ORDER BY lower(name)
from sqlobject.sqlbuilder import func
print list(Songs.select(orderBy=func.lower(Songs.q.name)))
