[Zope] ZSQL and Order By

[Colin Fox]

--=-nSYO4kbyQCupqUVFBu/k
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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

--=20
Colin Fox                                       cfox@crystalcherry.com
CF Consulting Inc.                                    GPG Fingerprint:
                    D8F0 84E7 E7CC 5C6C 9982  F1A7 A3EB 6EA3 BC97 572F

--=-nSYO4kbyQCupqUVFBu/k
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA83rd1o+tuo7yXVy8RAt/GAKDZKZVtwlNfdDSdQ611eDQTtAzmfACfejtt
tfHaheWEAKswsIu9MMrH1dQ=
=7Ds9
-----END PGP SIGNATURE-----

--=-nSYO4kbyQCupqUVFBu/k--