intranet database communication with internet database

[Guest]

I am not quite sure how to ask this, but...

We have a CF Server on an intranet server and a CF Server on our WWW server.

Question: Can Cold Fusion push out data internally to the WWW somehow. For example, if someone input information on a form and hit submit where the internal table was then updated, can CF push that updated record out to the mirror table on the WWW?

Hope this is kind of clear.

Thanks

[Newsgroup_User]

LeeBC wrote:
>
> Hope this is kind of clear.
>
> Thanks
>

Not really.

But I think you are asking can one CF server write data to two database
servers? The one you use internally on your Intranet and the one you
use externally on your 'WWW' site.

Then the answer is of course yes, as long as your network allows the CF
server to create a DNS to the second database server. You can have a
ColdFusion application write data to as many database servers as you
desire to connect it two. Each one would take its own <cfquery...>
block, but other then that it is easy to do.

I.E.
<cfquery dsn="internal"...>
INSERT INTO ...
</cfquery>

<cfquery dsn="www"...>
INSERT INTO ...
</cfquery>

But this is by no means the only way to do this. You could also have
the databases take care of this themselves through replication or
triggers or some other mechanism where data received by one database is
pushed to the other.

[Dan_Bracuk]

or you can use the same database for both internal and external.