Forgot one thing, this is on Django 1.0.2. Regards Darryl
On 22/05/2009 11:40 AM, Darryl Ross wrote: > Hi All, > > I have searched around but not really found an answer to this. For a > project I am working on the customer wants a list of publications to be > sorted alphabetically, but ignoring the definite/indefinite articles > "the/a/an". > > Eg, the list should sort like > > Adherence to ... > The Effects of ... > A Low Participation Rate ... > Trends in ... > Understanding ... > What Stops ... > > Is there a way of doing this using the ORM or a custom manager without > having to write custom SQL every time I need to get a list of publications? > > I found the following page which has a method of doing it for MySQL: > > http://expressionengine.com/wiki/Sort_Entries_by_Title_Ignoring_The_A_An/ > > -- Darryl Ross, VK5LBJ AFOYI, Information Technology Solutions e: [email protected] p: +61 8 7127 1831 f: +61 8 8425 9607 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" 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/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
