I made the following changes.
<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>
<cfif IsDefined("cgi.HTTP_HOST")>
<cfquery datasource="#datasource#" name="getCompanyURLs">
SELECT * FROM WebCompanies WHERE CompanyURL='#cgi.HTTP_HOST#'
</cfquery>
<cfif IsDefined("getCompanyURLs.CID")>
<!--- Set Variables for Company --->
<cflock type="exclusive" timeout="30"
name="#session.sessionID#" >
<cfset session.CID
=#getCompanyURLs.CID#>
<cfset session.CompanyID
=#getCompanyURLs.CompanyID#>
<cfset session.CompanyName
=#getCompanyURLs.CompanyName#>
<cfset session.CompanyAbbreviation
=#getCompanyURLs.CompanyAbbreviation#>
<cfset session.Provider
=#getCompanyURLs.Provider#>
<cfset session.CompanyLogo
=#getCompanyURLs.CompanyLogo#>
<cfset session.DarkColor
=#getCompanyURLs.DarkColor#>
<cfset session.LightColor
=#getCompanyURLs.LightColor#>
<cfset session.MedColor
=#getCompanyURLs.MedColor#>
<cfset session.BGColor
=#getCompanyURLs.BGColor#>
</cflock>
<cflocation url="http://#getCompanyURLs.CompanyURL#/site.cfm";
addtoken="no">
<cfelse>
<cflocation url="error.cfm?Error=NoReferer" addtoken="no">
</cfif>
<cfelse>
<cflocation url="error.cfm?Error=NoReferer" addtoken="no">
</cfif>
I am getting this error:
------------------------------------------------------------
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to
contact the server (Server returned: Connection reset). Please ensure that the
server parameters passed to the driver are correct and that the server is
running. Also ensure that the maximum number of connections have not been
exceeded for this server.
The error occurred in C:\Inetpub\WebSites\route.cfm: line 17
Called from Server returned: line -1
Called from C:\Inetpub\WebSites\route.cfm: line 17
15 :
16 : <cfquery datasource="#datasource#" name="getCompanyURLs">
17 : SELECT * FROM WebCompanies WHERE CompanyURL='#cgi.HTTP_HOST#'
18 : </cfquery>
19 :
--------------------------------------------------------------------------------
SQL SELECT * FROM WebCompanies WHERE CompanyURL='www.jisdbenefits.com'
DATASOURCE WebSites
SQLSTATE HY000
Resources:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
Remote Address 216.14.33.34
Referrer
Date/Time 23-Feb-07 09:54 AM
Stack Trace (click to expand)
at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:17)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A problem occurred
when attempting to contact the server (Server returned: Connection reset).
Please ensure that the server parameters passed to the driver are correct and
that the server is running. Also ensure that the maximum number of connections
have not been exceeded for this server. at
cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:17)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]A problem occurred
when attempting to contact the server (Server returned: Connection reset).
Please ensure that the server parameters passed to the driver are correct and
that the server is running. Also ensure that the maximum number of connections
have not been exceeded for this server.
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.receive(Unknown Source)
at
macromedia.jdbc.sqlserver.tds.TDSExecuteRequest.submitRequest(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown
Source)
at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at macromedia.jdbc.base.BaseStatement.execute(Unknown Source)
at
coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
at coldfusion.sql.Executive.executeQuery(Executive.java:753)
at coldfusion.sql.Executive.executeQuery(Executive.java:675)
at coldfusion.sql.Executive.executeQuery(Executive.java:636)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
at cfroute2ecfm1337773736.runPage(C:\Inetpub\WebSites\route.cfm:17)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at
coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at com.intergral.fusionreactor.filter.FusionReactorFilter.B(Unknown
Source)
at com.intergral.fusionreactor.filter.FusionReactorFilter.A(Unknown
Source)
at
com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(Unknown Source)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
------------------------------------------------------------
- JH
><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>
>
>
>Noticed this also I dont think this will cause a timeout but looks like a
>copy and paste error. The same query twice
>
>Eric
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270574
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
