I think I'll keep it relatively simple and use my normal update agent page and allow the display order number to be updated for a single agent, then automatically update the others in the subsequent query.
On the agent update page, I think I'll cook up a jQuery slide & show / slide & hide feature that will allow the manager to view the other agents' display order numbers, even though they will be non-editable. At least they'll know at a glance what number to assign to the new agent. You're right in that this will be an internal application where speed won't matter. It's also true that agents aren't added or deleted that often, so it won't be a daily routine where ease of use would be significant. Thanks for the help. Rick -----Original Message----- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 3:47 PM To: CF-Talk Subject: Re: How to re-order items? Yup, that's it exactly. It's not efficient from a speed standpoint but it should be fine for you, since presumably this will be an internal application. On your list of agents page, you could either have an "update" button for each row, or get a little fancier and allow "all at once" updating. This would probably require some dynamic field naming and a little more code to update all the agents' display order values. Then you would run the same re-ordering function as when you add the agent, to update all the display order values to multiples of 10. -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4