Thanks for responding Brian but Leigh's tip made it work >>> Brian McCairn <[email protected]> 10/22/2009 12:03 PM >>>
do you need those other columns? does <cfquery name="unique_info" dbtype="query"> SELECT distinct audit_org_type FROM list_audit_orgs </cfquery> work? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:327505 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
