Identifying the web site address of the current page

[Roger Withnell]

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?

 

[Bob Barrows]

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?

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

 

[Mark Reichard]

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

 

[Matt Simner]

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/default.asp?url=/library/en-us/iisref/htm/ref_vbom_reqocsv.asp

HTH,

Matt Simner