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]
