thats a pretty crappy host and i'd get rid of them disabling writing to the registry is one thing but cffile is another
---------- Original Message ---------------------------------- From: Nick Baker <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 16 Nov 2004 20:11:56 -0600 >My goal is to periodically extract and email MySQL records, for backup. (I >understand there are better ways to backup, but this is simpler for the >customer to deal with.). The simplest way I have found is to loop through >the query results and write to a file. Now I have encountered a host that >has CFFile disabled. > >Thought about is looping through the query loop and appending to a variable. > ><CFSET Olddata = "#Olddata##Newdata#"> ><CFMAIL to="[EMAIL PROTECTED]" > from=" [EMAIL PROTECTED] " > subject="DB Records"> > >#Olddata# > ></CFMAIL> > >Problems I see are 1. How would one get a line feed in between lines? 2. >The number of records can be 5-10,000. That seems a smitten too large to >put in a variable? > >Any other suggestions? > >Thanks, > >Nick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
