Use and indexed loop, multiply the loop count by 10 and use that value for record insertion...
On Wed, Mar 12, 2008 at 11: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:301138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4