superb - thanks duncan/tomo
I have used value list before - just found it in my code but I am not doing
enough consistent CF coding to remember all these things!
anyone have any tips on ways to remember much used or handy pieces of code -
I have started using snippets in DWMX a bit now?
_______________________________________________________
* 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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 15 March 2004 15:57
To: [EMAIL PROTECTED]
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]
