In this case where James is creating a CSV on the fly, he could name the file uniquely. I usually concatenate a file name with CreatUUID(). This way the file name is unique to the request, well as unique as the createUUID() function is.
Doug >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Thursday, March 13, 2003 4:04 PM >To: CF-Talk >Subject: Re: CFSTOREDPROC ? > > >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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
