An unexpected error occurred.

The web developers have been alerted.

struct
Cause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource db_Optimist
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
ErrorCode HY000
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT cm.Club_Number, dbo.TitleCase(cm.Name) Name, dbo.TitleCase(cm.City) City, cm.State_Province_Code, dbo.TitleCase(sp.State_Province) State_Province, case when cm.Country_Code='CN' then 'CA' else cm.Country_Code end Country_Code, c.Country_Name, tc.Type_Code_Description, cm.WebPage, cm.Sponsored_By_Club_Number, coalesce(scl.District_Number,cl.District_Number,left(scm.Club_Number,2),0) District_Number, cm.Status FROM JOOI..Club_Master cm INNER JOIN JOOI..Club_Types ct ON ct.Club_Type=cm.Type_Code and ct.Club=1 LEFT JOIN JOOI..Club_Location cl ON cl.Club_Number=cm.CLub_Number AND cl.Organization_Year=2019 LEFT JOIN Optimist..Club_Master scm ON scm.Club_Number=cm.Sponsored_By_Club_Number LEFT JOIN Optimist..Club_Location scl ON scl.Club_Number=scm.CLub_Number AND scl.Organization_Year=2019 INNER JOIN State_Province_Lookup sp ON sp.State_Province_Code=cm.State_Province_Code INNER JOIN Country_Lookup c ON c.Country_Code=cm.Country_Code LEFT JOIN JOOI..Type_Code_Lookup tc ON tc.Type_Code=cm.Type_Code, '' Status_Name WHERE cm.Status in ('A','P') and coalesce(scl.District_Number,cl.District_Number,left(scm.Club_Number,2),0)=49 ORDER BY tc.Sort, cm.Club_Number
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 42 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
where [empty string]
Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest.
Message Event handler exception.
RootCause
struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLException
DataSource db_Optimist
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
ErrorCode HY000
Message Error Executing Database Query.
NativeErrorCode 102
RootCause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SELECT cm.Club_Number, dbo.TitleCase(cm.Name) Name, dbo.TitleCase(cm.City) City, cm.State_Province_Code, dbo.TitleCase(sp.State_Province) State_Province, case when cm.Country_Code='CN' then 'CA' else cm.Country_Code end Country_Code, c.Country_Name, tc.Type_Code_Description, cm.WebPage, cm.Sponsored_By_Club_Number, coalesce(scl.District_Number,cl.District_Number,left(scm.Club_Number,2),0) District_Number, cm.Status FROM JOOI..Club_Master cm INNER JOIN JOOI..Club_Types ct ON ct.Club_Type=cm.Type_Code and ct.Club=1 LEFT JOIN JOOI..Club_Location cl ON cl.Club_Number=cm.CLub_Number AND cl.Organization_Year=2019 LEFT JOIN Optimist..Club_Master scm ON scm.Club_Number=cm.Sponsored_By_Club_Number LEFT JOIN Optimist..Club_Location scl ON scl.Club_Number=scm.CLub_Number AND scl.Organization_Year=2019 INNER JOIN State_Province_Lookup sp ON sp.State_Province_Code=cm.State_Province_Code INNER JOIN Country_Lookup c ON c.Country_Code=cm.Country_Code LEFT JOIN JOOI..Type_Code_Lookup tc ON tc.Type_Code=cm.Type_Code, '' Status_Name WHERE cm.Status in ('A','P') and coalesce(scl.District_Number,cl.District_Number,left(scm.Club_Number,2),0)=49 ORDER BY tc.Sort, cm.Club_Number
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 42 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''.
where [empty string]
StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:288) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:201) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:641) at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280) ... 28 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ''. at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source) at macromedia.jdbc.sqlserverbase.dda3.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.ddj.l(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source) at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348) at coldfusion.sql.Executive.executeQuery(Executive.java:1420) at coldfusion.sql.Executive.executeQuery(Executive.java:1183) at coldfusion.sql.Executive.executeQuery(Executive.java:1114) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) ... 42 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 67
RAW_TRACE at cfclub2ecfm1414647702.runPage(C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm:67)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\member\clubdirectory\club.cfm
TYPE CFML
2
struct
COLUMN 0
ID CFINCLUDE
LINE 144
RAW_TRACE at cfapplication2ecfc572326160$funcONREQUEST.runFunction(C:\inetpub\wwwroot\www.optimist.org\application.cfc:144)
TEMPLATE C:\inetpub\wwwroot\www.optimist.org\application.cfc
TYPE CFML
Type Database
name onRequest