You could use: SELECT DISTINCT city FROM profiles
Alex > -----Original Message----- > From: Brian Simpson [mailto:[EMAIL PROTECTED]] > Sent: 29 May 2002 10:32 > To: CF-Talk > Subject: CFQUERY Question to populate a drop down for search > > > 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> > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
