You might want to clarify what you mean by redirect. Are you referring to a 301 or 302 redirect? If so, then that is a problem. You write "redirects back to ColdFusion template 2, where the loop is continued" which doesn't correspond to what most people think of as the definition of "redirect" in the context of a browser requesting a page from a Web server.
-Mike Chabot On Mon, Nov 10, 2008 at 1:45 PM, Gary Chambers <[EMAIL PROTECTED]> wrote: > I have a unique task that involves retrieving data from one server, moving it > to another server, and then processing the data. I'm running CF8 on a linux > server. > > I wrote a ColdFusion program (call it template 1) to gather the data and > write it to a MySQL database table. This program calls another ColdFusion > program (call it template 2) which loops through the items in the MySQL > database; each loop making a call to a PERL script passing parameters. The > PERL sript telnets to another server passing the data and calling a program > on the new server. This program writes the data to a file (for later > processing) and control is returned back to the PERL script. The PERL script > then redirects back to ColdFusion template 2, where the loop is continued > until all the MySQL database table items have been processed. > > This process involves three servers, three databases, and three programming > languages; one server is PICK based and therefore somewhat tricky to > communicate with. > > This process runs fine when ran as a regular ColdFusion process, but when I > run it as a Scheduled Task it fails to complete. I runs through one item but > it seems as though the redirect from the PERL script fails. > > I understand that the Scheduled Tasks run as a 'CFHTTP' process and have > attempted to run the process using a <CFHTTP> function and can't get it to > work. I've never used <CFHTTP> and really don't understand what the premise > behind it is. > > I want this process to run every morning and would like to have it run > through a scheduler or as a CRON job. > > Does anyone have any ideas that may assist me? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:315058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
