28 Jun
2002
28 Jun
'02
6:07 p.m.
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 sort order via the query string (<a href="http://ut-web/applications/iw/plancheck/show_all_html2?order=Company"> Company</a> ) On the called page, I have the following line to sort the sql results but it seems to sort by something else and seems to be different each time. <dtml-in list_all_records sort="<dtml-var order> reverse" size=10 start=query_start> Order is the name of the variable for each database field. For example, sort could equal "Company" For whatever reason, I am getting weird results. I am still pretty weak at dtml so I am not seeing why. Sean