cheers tom
_______________________________________________________
* 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:24
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Best way to create semi-colon email list
I tend to use the online docs for reference as I can quickly hyperlink to
wherever I want... much quicker than trawling through the paper docs.
try:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/function.htm
should help:)
----- Original Message -----
From: "Lovelock, Richard J" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 4:18 PM
Subject: RE: [ cf-dev ] Best way to create semi-colon email list
> which docs exactly tomo? i have the CF reference manual here but that
isn't
> wholly useful sometimes - for instance i found the listappend but it
wasn't
> the most efficient tag in the circumstance!
>
> _______________________________________________________
> * 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:08
> To: [EMAIL PROTECTED]
> Subject: Re: [ cf-dev ] Best way to create semi-colon email list
>
>
> I tend to find the docs help a bit... especially when I can't remember the
> name of a function (there are some I rarely use), and just blasting
through
> the functions helps a great deal... quite useful really!:) Anyway, I
still
> swear by CF-Studio, which has an ace expression builder, which I really
use
> as a function reference. I seem to remember loads of people complaining
> about a lack of function reference in DWMX, has this been rectified yet?
>
> Cheers,
>
> Tom
> ----- Original Message -----
> From: "Lovelock, Richard J" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, March 15, 2004 4:00 PM
> Subject: RE: [ cf-dev ] Best way to create semi-colon email list
>
>
> > 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]
>
>
> --
> 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]
