sorting data dynamicly

[aviovda]

hello all

after lot of trying sorting data
getting dynamically the sort keys (get-value("sort1"),get-value("sort2") ect.

and trying to write something like that:
<!wss--
for each sofile no-lock break by get-value("sort1") by get-value("sort2") ...:

-->
<td> `field1` </td>
<td> `field2` </td>

<!wss--

end.
-->

i realized that data do not merge in the desired order (no-error occurs simply the data displayed in the original order they came into the temp table) can
i get help please.

thank you very much.

 

[gcampbell]

You'll need to use dynamic queries. Or load a Temp-table with the data and have a 'sort' field that is the key and is set to whatever the sort key is.

later,
Gordon