CFQUERY Question to populate a drop down for search I'm looking for a way to query a database table and display the results with out any diplicates.
The "WHERE city is unique" does not work. <CFQUERY name="getcity" DATASOURCE="datasource"> SELECT city FROM profiles WHERE city is unique </CFQUERY> <CFOUTPUT query="getcity"> <OPTION VALUE='#getcity.city#'>#getcity.city#</OPTION> </CFOUTPUT> ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists