you don't need the list change as you can specify the delimiter in the valueList() ... ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 3:56 PM Subject: Re: [ cf-dev ] Best way to create semi-colon email list
> > #ListChangeDelims(ValueList(getEmails.email), "; ")# > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > "Lovelock, > Richard J" To: "'cflist'" <[EMAIL PROTECTED]> > <richard.lovelock cc: > @cgey.com> Subject: [ cf-dev ] Best way to create semi-colon email list > > 15/03/2004 15:48 > Please respond to > dev > > > > > > guys > > what is the most efficient way to retrieve a list of emails from DB and > create a semi-colon separated list: > > at the moment, I have: > > <!--- Get EMails ---> > <cfquery datasource="fclounge" name="getemails"> > SELECT email > FROM contacts > where email <> '-' > </cfquery> > > <!--- Output results ---> > <cfoutput> > <cfdump var="#getemails#"> > </cfoutput> > > <!-- Create new blank list ---> > <cfset emails = ''> > > <!--- loop through query and append to list ---> > <cfloop query="getemails"> > <cfset emails = ListAppend("#emails#", "#email#", ";")> > </cfloop> > > <!--- Output final list ---> > <cfoutput><br> List is #emails#</cfoutput> > > - Is this the way to go? This is kinda working. How do I add a space in > after the ";" - i tried <cfset emails = ListAppend("#emails#", "#email#", > ";" & chr(32))> but that didn't work? > - Also, any email addresses with a hyphen in are being split over two lines > when I output the variable? > > > > > _______________________________________________________<?xml:namespace > prefix = o ns = "urn:schemas-microsoft-com:office:office" /> > > > * Regards, > Richard Lovelock, > Senior Application Analyst. > > > Westminster City Council - Web Support > Cap Gemini Ernst & Young > Southbank > 95 Wandsworth Road > London > SW8 2HG > > > ( 0870 906 7482 > > _______________________________________________________ > > > > > > ======================================================= > This message contains information that may be privileged or confidential > and is the property of the Cap Gemini Ernst & Young Group. It is intended > only for the person to whom it is addressed. If you are not the intended > recipient, you are not authorised to read, print, retain, copy, > disseminate, distribute, or use this message or any part thereof. If you > receive this message in error, please notify the sender immediately and > delete all copies of this message. > ======================================================= > > > > > -- > These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
