[Zope] Re: sorting SQL results with dtml-in - not working

[Derrick 'dman' Hudson]

--7AUc2qLy4jB3hD7Z
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Jun 28, 2002 at 11:07:05AM -0700, Kelley, Sean wrote:
| Hi,
| I am trying to provide a way to re-sort sql results in the form of a table
| by column name.  I have the column headings set as links which pass the s=
ort
| order via the query string

This sounds fine, but why not let the SQL backend do the sorting for
you?  Use the "ORDER BY <column name>" clause on your query.  You can
have the column to order by passed in as an argument (as you are
trying to do).

HTH,
-D

--=20

All a man's ways seem innocent to him,
but motives are weighed by the Lord.
        Proverbs 16:2
=20
http://dman.ddts.net/~dman/


--7AUc2qLy4jB3hD7Z
Content-Type: application/pgp-signature
Content-Disposition: inline

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

iEYEARECAAYFAj0eTkQACgkQO8l8XBKTpRQomACgkYEKDaHCUgKTbfazdONJwD0k
h7QAn04TjJwtHJQY007hTmK/hudTU31B
=BYzz
-----END PGP SIGNATURE-----

--7AUc2qLy4jB3hD7Z--