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.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
