Try using <cfoutput>#valuelist(getdirs.directoryid)#</cfoutput>
-----Original Message----- From: Ian Westbrook [mailto:[EMAIL PROTECTED] Sent: 24 July 2003 14:54 To: cfug dev list Subject: [ cf-dev ] I'm going mad... I'm having a _really_ bad coding day. The following is about as simple as it gets but I can't make it work as it should... can anyone tell me why this isn't working? <cfquery datasource="#dsn#" name="getdirs"> SELECT DISTINCT directoryid FROM diary </cfquery> <p>ids: <cfoutput>#getdirs.directoryid#, </cfoutput></p> there are three different directoryids in the diary table (1,14,15), so why the f&%k is this code only outputting: ids: 1, ?????? aaaahhhhhhhhh.... it was all going so well, too... TIA 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]
