>> 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:269863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
