Duncan - that gives a 404 error that link? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 16:26 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Best way to create semi-colon email list
print this off and stick it somewhere you can see it. Only up to date for version 4 / 4.5, but it still covers most of the common tags and functions you're likely to use: http://www.teratech.com/cfconf/TeraTechCFtagPoster.pdf 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: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> <richard.lovelock cc: @cgey.com> Subject: RE: [ cf-dev ] Best way to create semi-colon email list 15/03/2004 16:00 Please respond to dev 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]
