Thanks, everyone, for the suggestions.
Here's the final solution:
cfexecute code:
<cfexecute
name="C:\WINDOWS\system32\cmd.exe"
arguments="/c
e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\getfiles.bat"
timeout="10800">
</cfexecute>
batch file:
ftp
-s:e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\getfiles.txt
ftp commands file:
open datalink.interealty.com
anonymous
IDX292A
prompt
cd /DataLinkOutput/SAV/SAV_1000019201
lcd e:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files
mget *.*
bye
Glad that's working! Got to move forward with this app!
@Justin: I think I'm going to have to get a second account with MLXchange, too.
I don't see how the data-handling can be done when I'm just sent incremental
data
each day, but don't know whether those files are for insertion, deletion, or
updating!
Rick
> -----Original Message-----
> From: Justin D. Scott [mailto:[EMAIL PROTECTED]
> Sent: Saturday, September 06, 2008 12:54 PM
> To: CF-Talk
> Subject: RE: Trying to use cfexecute to run batch file...
>
> > However, I can't get any results except a timeout when I use
> > <cfexecute> to run the batch file.
> >
> > <cfexecute name="e:\adobe_site\getfiles.bat"
> > timeout="60">
>
> Based on the file sized that you're likely dealing with, the timeout is too
> low. I run my CDEXECUTE with a timeout of 10800 for IDX downloads...
>
> <cfsetting requesttimeout="10800" />
> <cfexecute name="#expandPath('.\FTPBatch.cmd')#" timeout="10800" />
>
> FTPBatch.cmd is in the same folder as the calling script and has all of the
> commands needed to get to the proper folder and run the ftp command line:
>
> @echo off
> e:
> cd \inetpub\wwwroot\mls\imports
> ftp -n -s:..\FTPScript.txt
>
> FTPScript.txt is also in the same folder as the calling script and has the
> actual FTP commands to execute (connect, user, pass, get, etc.). In my case
> the "imports" folder is directly below the folder where all the scripts and
> such are located.
>
>
> --
> Justin Scott, http://www.tlson.com/
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312126
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
