8 Replies Latest reply on Apr 24, 2014 8:36 AM by WolfShade

    Best way to submit a query recordset to a remote server

    WolfShade Level 4

      Hello, everyone.

       

      I've been tasked with a project that will involve querying a table on one server, then sending the data to a remote server that will take the data and insert it into another database (the two db cannot communicate directly with each other.)

       

      I've never had to do something like this, before.  What is the best way to achieve the desired results?  Is there a way to "submit" a query (anywhere from 1 to 5 records at any given time) to the remote server without incorporating WDDX?

       

      CF9 environment, soon to be CF10.

       

      V/r,

       

      ^_^