Skip to main content
A
Anonymous
July 23, 2008
Question

intranet database communication with internet database

  • July 23, 2008
  • 2 replies
  • 415 views
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
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
July 24, 2008
or you can use the same database for both internal and external.
N
Newsgroup_User
Inspiring
July 23, 2008
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices