Re: Best Way To Integrate Separate Web Sites using CF

2002-12-19 Thread Dick Applebaum
OK, It appears that you want to just be able to access another sites database records and files rather than to make sure that the databases/files of these sites are synchronized (contain each other's data). You can do this with a web service on each site that receives a request (from

Re: Best Way To Integrate Separate Web Sites using CF

2002-12-19 Thread Jon Hall
Sounds like you are using Access...if a better db server is not in the budget, you might want to investigate MySQL. That would allow you to make remote db connections. -- jon mailto:[EMAIL PROTECTED] Thursday, December 19, 2002, 1:15:56 AM, you wrote: C The databases will be on separate

Best Way To Integrate Separate Web Sites using CF

2002-12-18 Thread CounterCW
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

Re: Best Way To Integrate Separate Web Sites using CF

2002-12-18 Thread Dick Applebaum
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

Re: Best Way To Integrate Separate Web Sites using CF

2002-12-18 Thread Matt Robertson
I have a client with simple needs that let me use a simple solution for their five sites: Every site simply pointed to the same datasource for common content (and every site used identical db queries... the sites are near mirrors of one another). If you wanted to put the db on one of the web

RE: Best Way To Integrate Separate Web Sites using CF

2002-12-18 Thread Jim Davis
: Wednesday, December 18, 2002 6:10 PM To: CF-Talk Subject: Best Way To Integrate Separate Web Sites using CF 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

Re: Best Way To Integrate Separate Web Sites using CF

2002-12-18 Thread CounterCW
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