Is the database on a separate server or servers?
Does each site have a separate database, or do they sahre a common
database with a column in each table that identifies the site.
You can set up a shared database with each table having a layout such
as:
Create Table Customer
(
CustomerID Integer Identity Primary Key,
SiteID Char.
*
*
*
)
Then your queries could include site identifiers (or not)
SELECT * From Customer
WHERE SiteID = 'a'
SELECT * From Customer
WHERE SiteID IN ('a','c','d')
So, you could easily integrate the db.
I did a web site with 12 different magazines sharing a common set of
programs and 1 common database using the above design. They also
shared a common CF server.
Based, on the URL accessed initially, a session variable was set which
determined the look and feel of the site-- the common programs would
work slightly differently depending on the site being accessed.
As some others have mentioned, you could use CFMXJ2ee an something like
Websphere, JRun or Tomcat and deploy a different CF Server instance for
each site.
HTH
Dick
On Wednesday, December 18, 2002, at 03:10 PM, CounterCW wrote:
> What is the best way to synchronize multiple web sites so that if one
> website wants to share information with others, they can?
> For example, if you had these web sites: (each on different servers)
>
> a.com
> b.com
> c.com
> d.com
>
> If each of these web sites had information in a database, how could
> Coldfusion retrieve this information so that the "articles" of data
> could
> be seen on their own web sites? Keep in mind that these "articles"
> could
> contain images or other objects.
>
> Anyone have ideas? Thanks,
>
> --
> Mike.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
