ok im a complete newbie at sql, I bet you have heard that a 1000 times :) anyways I have my db set up and I am using the cfselect command to create a user selection box from the returned data, however the returned data contains many duplicates (which is correct) but I want to remove these duplicates, is there a simple way of doing it
e.g. wales wales wales people people many many many many is the returned data in the selection list and I want it to return wales people many I guess there will be a simple answer to this but I am blowed if I can find it anyways thanks for looking. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2915 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
