Re: XLS Connection
How do you close the file? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230496 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
RE: XLS Connection
You'll need to kill the process that's keeping a persistent file handle. Not all applications maintain file handles after they're done with them, but some do. After that, you should be able to delete the file. !k -Original Message- From: Randy Messer [mailto:[EMAIL PROTECTED] Sent: January 26, 2006 10:08 AM To: CF-Talk Subject: Re: XLS Connection How do you close the file? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230500 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
RE: XLS Connection
I nearly forgot, if you're running a windows machine, I believe you rename the file even if it's in use. If you increment it, than you could have a task clean them out or back them up. !k -Original Message- From: Randy Messer [mailto:[EMAIL PROTECTED] Sent: January 26, 2006 10:08 AM To: CF-Talk Subject: Re: XLS Connection How do you close the file? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230501 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
Re: XLS Connection
I don't really know (I've only done this with text or PDF files using java). How did you open it in the first place? Maybe that will give you some direction... Cutter Randy Messer wrote: How do you close the file? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230512 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
XLS Connection
I have an XLS mapped up. After I query it, I can not upload, delete or rename the XLS file due to sharing violation. Is there a method to end the process? I need to replace the xls file after the qry has run with another xls of the same name. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230445 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
Re: XLS Connection
Not entirely sure here, you'll have to read up a little more, but I know that when I 'open' a file with a java call then I must remember to 'close' the file as well, even with error trapping, or the file will remain open until I either a) recycle the CF server or b) recycle the machine itself (though it might only be 'a') Cutter Randy Messer wrote: I have an XLS mapped up. After I query it, I can not upload, delete or rename the XLS file due to sharing violation. Is there a method to end the process? I need to replace the xls file after the qry has run with another xls of the same name. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230460 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