That sounds like the approach I'm currently using in principle, I'm just doing the "insert correct number here" approach.
Two questions... 1) For my approach, I can't figure out how to loop the query, assign the CurrentRow value to the Display_Order number, then add 10 that number. My loops aren't changing the Display_Order number. Suggestions? 2) For your approach, want to share the js solution? I'm not much of a javascript coder, but perhaps it's doable... Thanks for the feedback, Dennis. Rick -----Original Message----- From: Dennis Powers [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 6:00 PM To: CF-Talk Subject: RE: How to re-order items? >> the best approach to ordering the display of Real Estate agents In just about all the applications we develop where sort order is required I supply a "sort" field which is a numeric (int) field in the table. I create a page that retrieves the records to be sorted and displays the relevant part of the records ie: picture name, product name ...etc in a form select box. then use a javascript routine to allow them to click on an item and move the items up or down in the order. The form gets submitted and the result page gets a list of ID's in sorted order. I loop through the ID's incrementing a counter and update the sort field for each ID with the counter. This gives the user full visual control without the "insert" correct number here problem. Best Regards, Dennis Powers UXB Internet - A website design and Hosting Company 690 Wolcott Road P.O. Box 6029 Wolcott, CT 06716 Tel: (203)879-2844 http://www.uxbinternet.com/ http://www.uxb.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:269874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
