-
1. Re: Best way to submit a query recordset to a remote server
What is running on the remote server? ColdFusion, .Net, PHP, Ruby, etc.? Or is the remote server the other database server?
-Carl V.
-
2. Re: Best way to submit a query recordset to a remote server
Hello, Carl,
Thanks for your reply. The receiving server is a CF server hooked to another db.
V/r,
^_^
-
3. Re: Best way to submit a query recordset to a remote server
WolfShade wrote:
... 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.)So, you have 4 servers: CF1<=>DB1 and CF2<=>DB2. What about CF1 bypassing CF2, and inserting the data to DB2?
-
4. Re: Best way to submit a query recordset to a remote server
Hi, @BKBK,
Not permitted.
It's kind of tedious, but what I've worked, so far, is to have CF1 select data from DB1, SerializeJSON the data, use cfhttp to POST the data to CF2.
THEN, CF2 DeserializeJSON the data back into a query object and insert that into DB2.
Unless you think there's a better way to do it?
V/r,
^_^
-
-
6. Re: Best way to submit a query recordset to a remote server
Thank you, @BKBK. I'll complete that procedure and mark it as correct.
^_^
-
7. Re: Best way to submit a query recordset to a remote server
I agree with @BKBK. Sorry for not following up yesterday; I was away from my desk all day.
-Carl V.
-
8. Re: Best way to submit a query recordset to a remote server
No worries, Carl. I appreciate all opinions on this matter, whether they concur or differ.
I'm in the process of finishing it. Minor tweaks, error trapping, etc.
V/r,
^_^