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:184511
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
