MySQL, as most SQL engines has sort capabilities. I use this feature in ZSQL method like this: Parameters : order mode ZSQL script: select field1, field2, field3 from mytable where (...) order by <dtml-var order> <dtml-var mode> Pass as strings to this ZSQL method : order : either 'field1', 'field2', 'field3' mode: 'ascending' or 'descending' The syntax may depend on your db engine. HTH --Gilles ----- Original Message ----- From: "Lucas Vogel" <vogell@yahoo.com> To: <zope@zope.org> Sent: Thursday, January 03, 2002 12:08 AM Subject: [Zope] sorting a table
I have a DTML method that calls a Z SQL Method and places the results into an HTML table. What I would like to do with the table is make the column headers sort the results in ascending and descending order when they click on the link. I haven't really seen any Howtos or anything in the Zope book that describes or explains what I'm trying to do. If someone could help me with this I'd appreciate it.
Thanks, Lucas Vogel
_________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )