Hi, Keith, and thanks for the reply. I'm using CF 4.5 (should have stated that earlier) so would I have the request scope available? And why would that be preferable to an application variable?
Part of the problem with your solution at this point is that the site is a demo (hopefully the companies will want to buy in) so there's no domain names. I guess I could setup a table with assumed domain names and corresponding BusinessID's. The BusinessID's are critical because I have to connect to a second database for information based on the BusinessID as a relational key. At first, I decided to use URL.BusinessID all through the site, but figured there had to be a global variable setup I could use for this. I'm just trying to make sure that when I demo the site off my server, that things will work properly as opposed to what's happening on my production box and localhost... For now, since the URL is the same for all the businesses, how would I establish which businessID to use except for attaching the BusinessID to the URL? Thanks for your help. Rick -----Original Message----- From: Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:07 PM To: CF-Talk Subject: One dynamic site for multiple indepentdent businesses Have done something similar, but query database first to have a list of businessIDs related to a domain name. In application.cfm, loop through the available list of domains/ids until find match with the domain being called. This becomes the businessID for the desired site. Then set the businessID in the request scope--as request.BusinessID. All through the site, any queries, etc. are based on this unique ID. No need to carry through on URLs, as the request scope keeps it. Hope this helps Keith Dodd [EMAIL PROTECTED] www.wingserv.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
