you could use a select box with some buttons to move the items up and down, then use the position in the list when it gets submitted to re order your items
I do this in some of my processes and it works quite well Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jason Sheedy Sent: Thursday, April 14, 2005 12:58 PM To: CFAussie Mailing List Subject: [cfaussie] ordering records by priority I'm creating a schedule application for our intranet and am looking for the most efficient way to list items by priority. The basic idea is that you can move items up,down, to top and to bottom in the priority list. Currently I store the priority as an integer and order by the priority field when displaying the list. However, there's quite significant overhead in updating each record when changing the priority. i.e. if I want to move the bottom item to the top I need to update every record with a new priority value. The alternative way I was thinking of doing it was by simply storing the parent id of each item in a linked list. However, the overhead in maintaining this is also quite significant. Anyone got any better ideas on how to do this? cheers, Jason Sheedy www.jmpj.net --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
