This is strange. I run this query and I get proper results (DateAdded is a DateTime data type):
SELECT PP.ProfileID FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 3 2 2 2 1 5 3 6 I add a distinct and I get SELECT DISTINCT(PP.ProfileID) FROM profilepicts PP WHERE PP.Live = 1 ORDER BY PP.DateAdded DESC RESULTS: 5 3 6 1 2 Why did 5 come first after I added the DISTINCT? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323375 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
