I really need help with this one. I use this page to route a user to a
specific URL depending on the HTTP_Host. Does anyone see anything in this code
that would cause a user's session to drop or cause a time-out on the server?
This is basically an app that has many different URLs but passes a CID to a
generic set of pages that displays the URL's site. (It is for school benefit
sites where each school has a different set of information, but the code is the
same for each site)
Thanks! JH
--------------------------------------------------------------------------------------
<cfquery datasource="#datasource#" name="getCompanyURLs"
cachedWithin="#CreateTimeSpan(0,0,30,0)#">
SELECT CID, CompanyURL FROM WebCompanies
</cfquery>
<cfif IsDefined("cgi.HTTP_HOST")>
<cflock type="exclusive" timeout="30" name="#session.sessionID#" >
<cfset session.CID ="">
<cfset session.CompanyID ="">
<cfset session.CompanyName ="">
<cfset session.CompanyAbbreviation ="">
<cfset session.Provider ="">
<cfset session.CompanyLogo ="">
<cfset session.DarkColor ="">
<cfset session.LightColor ="">
<cfset session.MedColor ="">
<cfset session.BGColor ="">
</cflock>
<cfloop query="getCompanyURLs" >
<cfif #cgi.HTTP_HOST# EQ #getCompanyURLs.CompanyURL#>
<cfquery datasource="#datasource#"
name="GetCompanyInfo">
SELECT * FROM WebCompanies WHERE
CID=#getCompanyURLs.CID#
</cfquery>
<cfquery datasource="#datasource#" name="getSiteInfo">
SELECT * FROM WebCompanies WHERE
CID=#getCompanyURLs.CID#
</cfquery>
<cfquery datasource="#datasource#"
name="getMainContentInfo">
SELECT * FROM WebMainContent WHERE
CID=#getCompanyURLs.CID#
</cfquery>
<!--- Set Variables for Company --->
<cflock type="exclusive" timeout="30"
name="#session.sessionID#" >
<cfset session.CID
=#getCompanyURLs.CID#>
<cfset session.CompanyID
=#getSiteInfo.CompanyID#>
<cfset session.CompanyName
=#getSiteInfo.CompanyName#>
<cfset session.CompanyAbbreviation
=#getSiteInfo.CompanyAbbreviation#>
<cfset session.Provider
=#getSiteInfo.Provider#>
<cfset session.CompanyLogo
=#getSiteInfo.CompanyLogo#>
<cfset session.DarkColor
=#getSiteInfo.DarkColor#>
<cfset session.LightColor
=#getSiteInfo.LightColor#>
<cfset session.MedColor
=#getSiteInfo.MedColor#>
<cfset session.BGColor
=#getSiteInfo.BGColor#>
</cflock>
<cflocation
url="http://#getCompanyURLs.CompanyURL#/site.cfm"; addtoken="no">
</cfif>
</cfloop>
<cflocation url="error.cfm?Error=NoReferer" addtoken="no">
<cfelse>
<cflocation url="error.cfm?Error=NoReferer" addtoken="no">
</cfif>
----------------------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270564
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
