Logic tier: (ColdFusion)
You could just have both servers have datasources set up and update both
simultaneously, like David said. If you're using Access, however, this
really won't work, unless you have the two servers mapped to each
other. Alternately, you could fire off a CFHTTP, calling a page on the
other server that performs the update.
Database tier: (your database)
I think this would be a lot cleaner, since you don't have two queries
for every "one" (which I think could messy, both maintenance-wise and
transactionally). However, the solution is pretty database-engine
specific. My first thought would be to place triggers on each table
that may change that automatically updates the other database on the
other server.
--
Billy Cravens
[EMAIL PROTECTED]
"AustralianAccommodation.com Pty. Ltd." wrote:
>
> I have dual sites running on 2 separate cf servers is there a way that I can
> update both databases when I am using one of my database update forms so
> that with one click of the form submit button it will take the form data and
> update both databases at the same time
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
