cfexecute

[cgsj_usa@yahoo.com]

Did the solution below work for you? Thanks.

Chris

[annabannana]

no it didnt,i had to use vb script in the end along with sql dmo

[cgsj_usa@yahoo.com]

Good morning. I just need a little clarification on how cfexecute works.
Please correct me if I am wrong, but I thought you used it to invoke processes
on remote servers. Is it just to invoke executables on the local server? If
not, how do you get it to work on remote servers 'cause me using UNC paths to
the executable (batch file) does not work. Any assistance would be greatly
appreciated. Thanks.

Chris

[Ekimov]

I need to execute a CNTRL-PAUSE|BREAK in a dos prompt window that is currently
open on the server. So I'm using CFEXECUTE to do this. However, when I use
the code below, it opens up a new dos prompt window, not the current one I have
open.

<cfexecute name="C:\WINNT\system32\cmd.exe" arguments="/c ^C"
timeout="30"></cfexecute>

My program won't work unless it uses the existing window. Somehow I need to
"focus" on the open window. Does anyone have a solution for this? Thanks.

[sk8save]

I'm running HTMLDOC (PDF creation via Deprecated HTML file) using cfexecute.
After it runs, I go see the PDF it created and I get some weird characters due
to the french contained in the HTML file. However, if I create a .bat file with
the same call, and run it locally in DOS, the PDF is fine in french. Why would
this be happening?

I'd also like to note that it seems to always hang on the second pass.
Rebooting the server seems to solve it. Ideas?

[drmaves]

I'm having trouble getting CFEXECUTE to execute a command. I'm trying to unzip
a file to a specific directory. The command works fine when I type it in the
command window but does not execute properly when I try it with CFEXECUTE.

It doesn't give me any errors so I'm not sure what I am doing wrong.

I've attached the code I'm using - any help would be appreciated.



<cfset extract_date = #dateformat(now(),"YYYYMMDD")#>

<cfexecute
name="c:\winzip\wzunzip.exe"
arguments="-n -ybc -yo c:\IDX-Data\#extract_date#_photos_daily.zip
c:\IDX-Data\Denver\">
</cfexecute>

[reactionnetworks]

Set a timeout value - same thing has happened to me. For example:


<cfexecute
name="c:\winzip\wzunzip.exe"
arguments="-n -ybc -yo c:\IDX-Data\#extract_date#_photos_daily.zip
c:\IDX-Data\Denver\" timeout="30">
</cfexecute>

[drmaves]

Thanks, that got the command to start up but now I'm having another problem.
Maybe you can shed some light on this...

The unzip process starts up but only extracts 117 files out of 3806. It seems
to be very consistent about this as it's the same number every time I run it
regardless of the value of the timeout. I've tried several timeout settings 0,
60, 120, 180 and 500.

Any ideas?

[edgriffiths]

there are at least two other ways to do this: find/buy a CFX tag that will
unzip for you, or use CFFILE to dynamically write a DOS-style batch file that
will perform the unzip operation, then CFEXECUTE the batch file.

[PaulH]

have you tried one of the zip function from [url]www.cflib.org[/url] or the zip CFC in the
[url]http://www.macromedia.com/cfusion/exchange/index.cfm?view=sn130#view=sn131&viewN[/url]
ame=ColdFusion%20Extension&loc=en_us&authorid=6539 0183&page=0&scrollPos=0&subcat
id=0&snid=sn131&itemnumber=0&extid=1026507&catid=0 ?