I've got a table with two date columns. Either of the dates may not exist. My desired sorting algorithm is: if date1 exists, use it for the sort, but if it doesn't and date2 exists, then use it for the sort, if both dates exist sort by date1 first then by date2. The last clause is not essential but the first two are.
I could certainly do this with python sorting, but if my object is an SO SelectResults instance, perhaps there is some clever SQL/SQLBuilder way to do the sort more efficiently? --RDM --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
