I wouldn't advise creating seperate tables per country you wish to support. One, it would be a nightmare to maintain and Two there are much better ways to do this.
Try something more along the lines of: TBL_Content - Hold the content TBL_Country - Holds country identifiers and data TBL_Country - Relates content to a specific country In Ewok's example if you had anews story that was worldwide you would end up with duplicate records in the multiple tables. -Adam On 8/8/05, Ewok <[EMAIL PROTECTED]> wrote: > How about just sharing a datasource? > > You could have the main tables that are shared across the sites then you > could have individual news tables or whatever else needs to be specific to > certain sites. One update to the main shared tables would reflect across all > the sites and individual table updates would only show on the sites that > query those tables. > > Tbl_main_bulk_info > > Tbl_US_News > Tbl_UK_News > > Tbl_US_Events > Tbl_UK_Events > > Etc... > > Depending on your table naming conventions, you could even make it that much > easier by setting a variable on the individual sites like... > > <cfset countrycode = "US"> > > Then when you query say the news for the site you query > "tbl_#countrycode#_news" > > The code would be the same on all sites > > Just some thoughts > > > -----Original Message----- > From: Butch Zaccheo [mailto:[EMAIL PROTECTED] > Sent: Monday, August 08, 2005 12:47 PM > To: CF-Talk > Subject: Deployment of Multiple Websites with almost identical Info > > Hi Everyone, > > My company has asked me to deploy multiple websites for multiple countries > each with it¹s own domain. Each country will have info slightly modified to > reflect their own information (events, news, special promos), but the bulk > of the information will be the same. > > Here¹s my question: > > 1. What are other web developers doing in this circumstance? > 2. Is there cf content management software that would allow me to use > multiple domains and maintain only one whole site, sharing pages that would > be the same for every site? > 3. Or should I deploy a site for each domain and update each manually even > though most of the info is the same? > > Hopefully this isn¹t to broad a question for this list. I¹m very interested > to find out if others in the CF community already have working solutions. > > Any help would be much appreciated. > > Butch Zaccheo > Web Development > Edirol Corporation > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
