how about, with sql update all display-order greater than new value (in your example 15), incrementing by 10 then update display order = 20 where currently = 15
On Thu, Mar 13, 2008 at 12:05 PM, Rick Faircloth <[EMAIL PROTECTED]> wrote: > I know that doesn't sound like it's CF-related, but the solution > probably will be in CF, I'll bet. > > Anyway.I want to be able to determine the appearance order of > Real Estate agents on a page, other than by last name, etc. > > I want a user to be able to specify the appearance, say, by number. > I could have an "display-order" column and use a number. > > I would also want to have the numbers round up to the nearest 10 > whenever a new agent is entered or when an agent's display order is > updated. > > Say, I've got two agents in the db. First has display-order 10, second > has > display-order 20. A third agent is added who is to be displayed second, > so > is given the display-order number 15 in the form. When the form is > submitted, > the first agent retains number 10, the new second agent's number is > rounded up from 15 > to 20, and the agent whose number was 20 now has the number 30. That way > there > are always values between the agents' display-order numbers to add new > agents. > > Make any sense? > > Would this be the best way to do this? Other ways? > > Thanks, > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4