Re^3: How to let a user sort a list on a web page

Add a SortOrder column to your database and let the manager edit the values in that column for each row. Each time you fetch the data for display append "Order By SortOrder" to the SQL.

True laziness is hard work

Comment on Re^3: How to let a user sort a list on a web page

Replies are listed 'Best First'.
Re^4: How to let a user sort a list on a web page by Anonyrnous Monk (Hermit) on Dec 21, 2010 at 21:55 UTC
Personally, if I were a manager, I would rather like to simply click-n-drag the individual rows up and down. Somewhat like you can rearrange Firefox' tabs, only vertically. Having to enter numbers for this seems a little web-1.0-ish to me. Unfortunately, the already mentioned jQuery datatables plugin doesn't provide that functionality, AFAICT (I'd like to be proven wrong) - although it's an otherwise very neat widget. So, if anyone is aware of some other js library which can do it, please tell...	[reply]
Re^5: How to let a user sort a list on a web page by GrandFather (Saint) on Dec 21, 2010 at 22:28 UTC
There are two parts to the problem - persisting the sort order and setting the sort order. Persisting the sort order is server side and easily handled as suggested. Setting the sort order requires client side scripting support and is the harder problem to solve, and also somewhat off topic for this site (although I don't see that as an impediment to someone here providing a solution). True laziness is hard work	[reply]