in case anyone stumbles on this thread and has a similar issue, i managed to do
a work around which looks at the file size every 3 seconds. if the file size
has changed it reloops as it knows it is still building it. when the file size
does not change then it knows it has finished and comes out of the loop:
<cfset sleepObject = createObject("java", "java.lang.Thread") />
<cfset executeComplete = false />
<cfset currentFileSize = 0 />
<!--- run through a loop every 5 seconds to see if the size of the file has
changed, if yes then it means it is still executing, else it has finished and
the loop can stop --->
<cfloop condition="executeComplete eq false">
<cfset sleepObject.sleep(5000)>
<cfset fileSize = getfileinfo("#filepath#.sql") />
<cfif fileSize.Size neq currentFileSize>
<cfset currentFileSize = fileSize.Size />
<cfelse>
<cfset executeComplete = true />
</cfif>
</cfloop>
> hi
>
> i am running a cfexecute to run the mysqldump command at set times of
> the day. i want it to produce the dump file, zip up the file, and then
> email it to us before deleting the files.
>
> i have got it all working but the problem is: how can i detect when a
> cfexecute has finished. i could obviously set a timeout on the tag but
> the timeout varies and sometimes takes very long.
>
> the problem is that even if the dump has not finished the cfzip
> command starts to run
>
> thanks for any help
>
> richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321410
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
