Why not just use a date instead. This date could be from their longevity with the current agency, or their time as an agent overall or even both. you could have drop down in the admin section to allow them to oder by whatever criteria they prefer.
Doug B. ----- Original Message ----- From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Tuesday, February 13, 2007 11:41 AM Subject: How to re-order items? > Hi, all. > > I'm trying to figure out the best approach to > ordering the display of Real Estate agents on > a website. > > I have it by last name currently, but my client > wants to re-order by Seniority. > > So, I figured I'd just put a field in the database > called "Display_Order" and then the person who > manages the site could provide a number for > each person. e.g. 1 on top, 2 next, etc. > > The problem would come when an agent > gets added to the list who would be between 1 and 2. > (I don't want to use decimals). > > I can instruct the manager of the site to put 10 for the top > spot, then 20 for the second, etc. That leaves room for > additional spots to be added between 10 and 20. > > However, I'm looking for a long-term solution. > > Would it be a good approach to have them initially number > the agents starting with 10, then 20, and have them say, use > 15 if someone needed to between 10 and 20, but code the > site so that all number are rounded up to increments of 10 > upon entry into the database? > > 10 stays 10, but 15 becomes 20, 20 becomes 30, etc. > > Is that a good solution? What other solutions have any > of you used for this? > > Thanks for the insight. > > Rick > > (Remember. CF 4.5 here. :o) > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:269680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
