First thing to do would be dump the query, see if it's problem with the data coming back.
Ade -----Original Message----- From: Ian Westbrook [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 15:31 To: cfug dev list Subject: [ cf-dev ] another one... couldn't get that last one working - worked once then stopped. Oh well. I'll try again tomorrow. on to the next annoyance. trying to output a drop-down list of towns where there are events hapening in that town in the events Diary. The relevant tables/fields are: table: diary id directoryid (= directory.id) ... table: directory id town ( = towns.id) ... table: towns id town this is the query: <cfquery datasource="#dsn#" name="gettowns"> SELECT DISTINCT directory.town AS townid, towns.id, towns.town, diary.directoryid, directory.id FROM diary, directory, towns WHERE diary.directoryid = directory.id AND directory.town = towns.id ORDER BY towns.town </cfquery> and this is the output: <select name="town"> <option value="all">all towns/cities...</option> <cfoutput query="gettowns"> <cfif NOT ISDefined("url.townid")> <option value="#townid#">#town#</option> <cfelse> <option value="#townid#"<cfif gettowns.townid IS url.townid> selected</cfif>>#town#</option> </cfif> </cfoutput> </select> it's all working fine, except that I'm getting a town's name output twice on the drop-down, and I only want it the once (which is where the DISTINCT is meant to come in) see it here: http://test.artsoutheast.co.uk/diarysearch.cfm?CFID=1290809&CFTOKEN=50249308 &sortby=quick&townid=21 I've tried making other items DISTINCT, but I can't seem to get it to work anywhichway... can anyone put me out of my misery? If I had any hair left I'd be pulling it out... Ian W Ian Westbrook, FutureDream Media Limited, (W): www.futuredream.net (E): [EMAIL PROTECTED] (T): +44 (0) 1303 258 985 (M): 07939 510 812 This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding any comments, opinions, information or conclusions expressed in this message are those of the originator, not of FutureDream Media Ltd, unless otherwise explicitly and independently indicated by an authorised representative of FutureDream Media Ltd. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
