[Zope] sorting a table

[hans]

quoted manually from digest:

>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.

in DTML it looks like this for eg. sort col = FIELD:
make the column heading an URL:

  <th>
  <a href="<dtml-var document_id
                      >?col=FIELD&dir=<dtml-if "col=='TOP_NAME' and
dir=='asc'"
                                                         >desc<dtml-else

                                                         >asc</dtml-if>"

   >Topic
    <dtml-if "col=='FIELD'"><dtml-if
"dir=='asc'">V<dtml-else>A</dtml-if><dtml-else>=</dtml-if
  ></a>
  </th>