You can do this by creating two custom columns in your search action. Call one @@local$sortAsc and the other @@local$sortDesc. Drag them both into the Order by box and sort one ascending and the other descending.
Then at run time set local$sortAsc to the column name and local$sortDesc to NULL (or vice versa) to sort ascending or descending on any column in the table. Dave Shelley -----Original Message----- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Thursday, October 21, 2004 1:04 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Sort order in search actions In a search action, one sets the sort fields and the ASC DESC sort orders. Is there any way to control the sort order (ASC DESC) by a variable? One can always sort the resultset, but that's only sorting the piece of the totalrows ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
