I have several web sites running the same set of pages and
all accessing the same common database tables. A field in
all the records contains the web site address of the web
site to which each record pertains, for example, this
field in some records may contain www.upperbridge.co.uk.
When a web site page accesses a database table, it needs
to select the records that contain its web site address.
How do I identify which web site this page is in? For
example, if a page is part of web site
www.upperbridge.co.uk, how does the page get hold of this
web site address so it can use it to select the correct
records in the common database tables?

Roger Withnell wrote:[color=blue]
> I have several web sites running the same set of pages and
> all accessing the same common database tables. A field in
> all the records contains the web site address of the web
> site to which each record pertains, for example, this
> field in some records may contain www.upperbridge.co.uk.
> When a web site page accesses a database table, it needs
> to select the records that contain its web site address.
> How do I identify which web site this page is in? For
> example, if a page is part of web site
> www.upperbridge.co.uk, how does the page get hold of this
> web site address so it can use it to select the correct
> records in the common database tables?[/color]

A servervariable should contain this info. I don't feel like going to look
up which one at the moment, but you can generate all the servervariables
like this:

for each item in request.servervariables
response.write item & ": "
response.write request.servervariables(item) & "<BR>"
next

HTH,
Bob Barrows

Roger,

Use request.servervariables("SERVER_NAME"). That's exactly what that
function is for. Even for multiple sites on the same server, it will
return the site URL.

Thanks,
Mark

Simple Content Management -- http://www.synapsecm.com
Multilingual Web Development -- http://www.idataconsultingservices.com

Hi Roger,

If I understand correctly - you basically want to know the host name
from each page.

try using ...

Request.ServerVariables("SERVER_NAME")

This should contain the 'host name' for that page e.g.
www.upperbridge.co.uk

Look at this MSDN article for all of the other ServerVariables you can
access...

http://msdn.microsoft.com/library/de...om_reqocsv.asp

HTH,

Matt Simner


"Roger Withnell" <roger@upperbridge.co.uk> wrote in message news:<2025201c38a87$dc8270e0$a601280a@phx.gbl>...[color=blue]
> I have several web sites running the same set of pages and
> all accessing the same common database tables. A field in
> all the records contains the web site address of the web
> site to which each record pertains, for example, this
> field in some records may contain www.upperbridge.co.uk.
> When a web site page accesses a database table, it needs
> to select the records that contain its web site address.
> How do I identify which web site this page is in? For
> example, if a page is part of web site
> www.upperbridge.co.uk, how does the page get hold of this
> web site address so it can use it to select the correct
> records in the common database tables?[/color]