[Zope] ZSQL and Order By

I want to make a page that shows a list, and allow that user to click on a column of the list and sort the list by that column. It seems to me that the obvious way to do this is to re-issue the SQL command and use a different 'order by'. First - Is this actually the best way to do this kind of thing in Zope? Second - How do I create a ZSQL script that contains a variable order by? Thanks, Colin -- Colin Fox cfox@crystalcherry.com CF Consulting Inc. GPG Fingerprint: D8F0 84E7 E7CC 5C6C 9982 F1A7 A3EB 6EA3 BC97 572F