The databases will be on separate servers.
So, unfortunately, I won't be able to do SQL statements.
Is there another method I can use?
--
Mike
At 04:24 PM 12/18/02 -0800, you wrote:
>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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
