You might want to put an insert trigger on your 'primary' database tables.
When a record is inserted, the trigger would insert the same record into the
other database. Also, same thing goes for updates and deletes.
-----Original Message-----
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 5:29 AM
To: CF-Talk
Subject:
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.
