On Wed, Jan 18, 2006 at 06:19:13PM -0800, Stephen Hassard wrote:
> One of my queries is sorting output from a database. The sort is working
> properly, but is returning lower case results after the upper case ones,
> ie: A, B, C, a, b, c. Is their any way to tell SQLObject to tell sqlite
> to sort without case sensitivity?
Hint: SELECT * FROM atable ORDER BY lower(name)
> Another query that I'm performing returns results that have associated
> objects with a one-to-many relationship (RSS feed, with the many objects
> being the individual RSS entries). Currently, the associated objects are
> returned in the database order. Is their a good way to sort the objects,
> or do I need to construct individual queries for the sub-objects so that
> they can be sorted?
other_table = MultipleJoin("OtherTable", orderBy="column")
Oleg Broytmann http://phd.pp.ru/ phd@...
Programmers don't die, they just GOSUB without RETURN.