Thanks, Dave. Perfect answer. david (other)
On Sunday, March 23, 2003, at 12:42 PM, Dave Carabetta wrote: >> Am trying to sort prices, highest to lowest and am running into a >> problem. >> >> For instance, 3 items are priced at 129.99, 99.99 and 8.99. Unless I >> insert a blank space in front of the 8.99 price in the actual >> database, >> it insists in sorting in front of 99.99. >> >> Using both CF DollarFormat and CF NumberFormat (coding for a CF 4.5 >> server). Any ideas on what I'm missing will be greatly appreciated. > > What is the datatype of that column? If it's not a float (or other > appropriate numeric datatype), that's where your problem is. > > Regards, > Dave. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4