hey all,
I am using win2k, CF MX (Updater 3) and IIS 5. We have got a server that is connected to a clients backend office server via an ISDN line. This ISDN line is used to send data (in CSV file format) between the two servers.
I am using CFHTTP to make the connection between the servers to drag the information from one, into a query and then loop over it to put it into the SQL Server database on our webserver. Now the problem seems to be that the data maybe corrupt, but I can get CFHTTP to tell me an error code of why its failing using the CFHTTP.StatusCode or what its bringing back using CFHTTP.FileContent, as it says something like StatusCode is undefined in CFHTTP, or something to that effect.
Thanks for reading this far, not long to go now!
This has been working on and off since the launch of the website. The client has sent us through a data file that is refusing to go through on the server. When we run it it just bring up our error message to the user and as I say above FileContent and StatusCode throw an error for some reason.
Does anyone know of a problem with CF MX with CFHTTP in updater 3, that might have caused this?
I just wanna check that its not the app server before we throw this back into the clients backend systems developers court.
In hindsite there are several other ways that I could have done this, but this seemed like the best way at the time.
Any help appreciated
Tony
I am using win2k, CF MX (Updater 3) and IIS 5. We have got a server that is connected to a clients backend office server via an ISDN line. This ISDN line is used to send data (in CSV file format) between the two servers.
I am using CFHTTP to make the connection between the servers to drag the information from one, into a query and then loop over it to put it into the SQL Server database on our webserver. Now the problem seems to be that the data maybe corrupt, but I can get CFHTTP to tell me an error code of why its failing using the CFHTTP.StatusCode or what its bringing back using CFHTTP.FileContent, as it says something like StatusCode is undefined in CFHTTP, or something to that effect.
Thanks for reading this far, not long to go now!
This has been working on and off since the launch of the website. The client has sent us through a data file that is refusing to go through on the server. When we run it it just bring up our error message to the user and as I say above FileContent and StatusCode throw an error for some reason.
Does anyone know of a problem with CF MX with CFHTTP in updater 3, that might have caused this?
I just wanna check that its not the app server before we throw this back into the clients backend systems developers court.
In hindsite there are several other ways that I could have done this, but this seemed like the best way at the time.
Any help appreciated
Tony