Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > ColdFusion > loop on cfile s...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 1649 of 1695
Post > Topic >>

loop on cfile statement

by vncntj@[EMAIL PROTECTED] Feb 12, 2007 at 04:07 PM

I'm creating outlook appointments from existing events with a
database.  Currently I'm at record 4 and slowly making my way to
record 9000.  This is my dilema.  Does anyone have any suggestions, on
how I can make this process a lot easier and prevent me from hiring a
Temp.

:)



<cfquery datasource="BLAH" name="Events">
Select Email, Yr,Mh,Dy,Locations,EventTitle from SpecialEvents
Where Id Like 4
</cfquery>
<cfoutput query="Events">
</cfoutput>
<cffile action =  "write"
	 file="C:\events\4.ics"
	output =
"BEGIN:VCALENDAR
PRODID:-//Microsoft Cor****ation//Outlook 11.0 MIMEDIR//EN
VERSION:1.0"
>
<cfloop query="Events">
	<cffile action="append"
	 file="C:\events\4.ics"
	 output=
"
BEGIN:VEVENT
ORGANIZER:MAILTO:#EMAIL#
DTSTART:#YR##DateFormat(MH,"MM")##DateFormat(DY,"DD")#T160000Z
DTEND:#YR##DateFormat(MH,"MM")##DateFormat(DY,"DD")#T170000Z
LOCATION:#LOCATIONS#
SUMMARY:#EVENTTITLE#
END:VEVENT
"
>
</cfloop>

<cffile action="append"
	 file="C:\events\4.ics"
	 output=
"END:VCALENDAR"
>
 




 2 Posts in Topic:
loop on cfile statement
vncntj@[EMAIL PROTECTED]   2007-02-12 16:07:19 
Re: loop on cfile statement
Bob Dively <dive@[EMAI  2007-02-13 14:49:32 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Jul 26 0:09:40 CDT 2008.