Hi there, This is my first post, so please be gentle.
I'm writing an application to aggregate RSS feeds into a sqlite database (using SQLObject) and then output the data to a static HTML file using Cheetah. Everything is working fairly well, but I have a few quick questions.
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?
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?
Thanks, Steve Hassard ------------------------------------------------------- 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
