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]
