Is seniority based on hire date? -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 2:39 PM To: CF-Talk Subject: RE: How to re-order items?
Glad to know the idea works in practice! Thanks, Josh Rick -----Original Message----- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 1:55 PM To: CF-Talk Subject: Re: How to re-order items? That is exactly what I do in a similar situation, and it works fine. -- Josh ----- Original Message ----- From: "Rick Faircloth" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, February 13, 2007 10: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:269699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4