House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Talk (CF-Talk)

Loopy Loop & Fast SOLVED

  << Previous Post |  RSS |  Subscribe to this Group Next >> 

Loopy Loop & Fast SOLVED

Thanks for all the help. Chris Edwards 04/01/2003 12:04 PM

04/01/2003 12:04 PM
Author: Chris Edwards Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:22829#115071 Thanks for all the help. Takes ~ 14 seconds.  Down from the original ~180 <!--- get email list ---> <cfquery name="list" datasource="#Request.App.Db#"> SELECT DISTINCT CONCAT(email,'\r\n') AS email FROM `mail_subscriptions` #optlist# </cfquery> <cffile action="write" file="#ExpandPath("users.lst")#" output="#valuelist(list.email,"")#"> Once again, the DB shines through as the savior. Thanks Doug for reminding me. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 chris.edwards@obinet.com http://www.OuterBanksInternet.com
<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

October 23, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Designer, Developer and mobile workflow conference