2) It is recommended that you always use <cflock> with <cffile>. You would do an exclusive lock for writing/deleting/copying. You would do a readonly lock for reading.
I'm not sure about CFMX though. I'm fairly certain that the java.io classes aren't threadsafe. ----- Original Message ----- From: James Blaha <[EMAIL PROTECTED]> Date: Thursday, March 13, 2003 1:26 pm Subject: CFSTOREDPROC ? > Hello All: > > CFSTOREDPROC ? > > Im on an adventure with my SQL 7.0 server and I have a question. > What > Im attempting to do is run a <CFSTOREDPROC> that generates a > large CSV > file from an executed DTS package and then output that file to a > network > share which the DTS will take care of. Next Im going to have my > CF > server zip that file and serve it to the user. So happy they will > be to > have their data. > > 1. While that file is being generated and ColdFusion is zipping up > that > file is there a way to track the progress and let the user know > how long > they have to wait? > > 2. Can I lock the CSV file thats being created in case someone > else > makes the same requeest tring to over write the file being created > by > the DTS package? > > > A Special Thanks Today To: Dan Switzers, write up on how to > execute a > DTS package from a stored procedure talk about cool. > > You can see his example at: > > http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS > > > > Regards, > James Blaha > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
