view the source of the page, it'll just be wrapping at the most convenient point I'd wager... but your other point is weird! ----- Original Message ----- From: "Lovelock, Richard J" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 15, 2004 4:10 PM Subject: RE: [ cf-dev ] Best way to create semi-colon email list
> hey weird ... get this > > indeed tomo .... > > if i use <cfset emails = valuelist(getemails.email, ";")> then it splits up > my email addresses which have hyphens in them - so i am not sure they will > work in a cfmail tag then? > > BUT > > when I use <cfset emails = valuelist(getemails.email, "; ")> (i.e. add the > space after the semi-colon) the list gets formatted correctly and the space > is included after the semi-colon (which doesn't work with the listappend > method) > > strange!!?? > > _______________________________________________________ > * 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 > > _______________________________________________________ > > > -----Original Message----- > From: Tom Smith [mailto:[EMAIL PROTECTED] > Sent: 15 March 2004 16:04 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] Best way to create semi-colon email list > > > 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] > > -- > 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]
