> How would I use the Round function (or something else?) > to change the numbers up to the next number evenly > divisible by 10?
Hey Rick, What I do is, submit the 14 into the db...re-query, ordering by display order...loop over the query, updating each entry setting displayorder = #currentRow# * 10. This will re-order everything and put your multiples of 10 into the db in the correct order -- you don't have to deal with handling the form values and trying to re-order them before entering them into the db. Let me know if you need more explanation. -- 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:269816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
