Sorting by field

[fatstu]

Im looking to sort a repeat region by the date field as default. Easily done i.e. ORDER BY date. I want to add functionality that lets you sort by other fields e.g. name, address etc etc. Going back to the ORDER BY [field] statement, is it possible to make this dynamic? Or would I need to physically make the additional pages with differing recordsets?

 

[Bastien]

you could add a checkbox or radiobutton to allow the user to pick the sort.

i believe it is also possbile to sort dymanically clientside by using javascript and getrow functionality, but the js would be pretty complex

hth

Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[fatstu]

id prefer server side to be honest

 

[JuanitaC]

Have a select box with your column names in it and on change, post back to the same page. In your SQL statement, use the value from the select box to determine the order by:

If Len(varColumn)=0 then 'no value chosen in select box
SQL = "SELECT * FROM Table Order by Date" 'default order by
Else
SQL = "SELECT * FROM Table Order by " & varColumn
end if

 

[fatstu]

GOOD LAD, THANKS