B&B - 500

500

Désolé, une erreur s'est produite.

L'administrateur du site a été informé. Merci

Cliquez ici pour retourner à la page d'accueil

struct

Cause

struct

ErrorCode

156

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'.

NextException

struct

ErrorCode

319

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

NextException

struct

ErrorCode

8180

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

SQLState

HY000

StackTrace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|) at macromedia.jdbc.sqlserver.base.fg.$fr$execute(|SQLServer|6.0.0.1282|:525) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1680) at coldfusion.sql.Executive.executeQuery(Executive.java:1406) at coldfusion.sql.Executive.executeQuery(Executive.java:1336) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor126.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor125.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|) at macromedia.jdbc.sqlserver.base.fg.$fr$execute(|SQLServer|6.0.0.1282|:525) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1680) at coldfusion.sql.Executive.executeQuery(Executive.java:1406) at coldfusion.sql.Executive.executeQuery(Executive.java:1336) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor126.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor125.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|) at macromedia.jdbc.sqlserver.base.fg.$fr$execute(|SQLServer|6.0.0.1282|:525) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1680) at coldfusion.sql.Executive.executeQuery(Executive.java:1406) at coldfusion.sql.Executive.executeQuery(Executive.java:1336) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor126.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor125.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

Type

java.sql.SQLException

DataSource

studioscivoletto

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'.

ErrorCode

HY000

Exceptions

array

struct
class	java.sql.SQLException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'.

struct
class	java.sql.SQLException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

struct
class	java.sql.SQLException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

Message

Error Executing Database Query.

NativeErrorCode

156

RootCause

struct

ErrorCode

156

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'.

NextException

struct

ErrorCode

319

Message

NextException

struct

ErrorCode

8180

Message

[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.

SQLState

HY000

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

Sql

DECLARE @numeroOspiti INT = (param 1) ; DECLARE @numeroGiorni INT = (param 2) ; DECLARE @filtroCancellazioneGratuita BIT = (param 3) ; DECLARE @checkInDate DATE = (param 4) ; DECLARE @checkOutDate DATE = (param 5) ; DECLARE @checkOutDateMin DATE = (param 6) ; DECLARE @diffChecInNow INT = DATEDIFF(day, (param 7) , @checkInDate); DECLARE @tmpHotelId TABLE (hotelId INT, ghostRoom BIT); INSERT INTO @tmpHotelId(hotelId, ghostRoom) SELECT hotelId, ghostRoom FROM (VALUES (0, 0) , (38715, 0) , (4187, 0) , (41610, 0) , (31645, 0) , (2476, 0) , (34215, 0) , (8513, 0) , (2131, 0) , (37614, 0) , (32664, 0) , (32593, 0) , (40441, 0) , (40373, 0) , (38401, 0) , (22934, 0) , (31336, 0) , (26415, 0) , (33051, 0) ) T(hotelId, ghostRoom); WITH N AS ( SELECT TOP (@numeroGiorni) ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 AS n FROM sys.all_objects a ), stayDateTable AS ( SELECT DATEADD(DAY, n, @checkInDate) AS stayDate FROM N ), WITH calendario AS ( SELECT h.hotelID , r.roomID , ( ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS singlePrice_discount , ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS basePrice_discount , ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS extraBedPrice_discount , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) - ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS extraBedPrice_infants_discount , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) - ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS extraBedPrice_children_discount , ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END ) AS singlePrice_total , ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END ) AS basePrice_total , ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END ) AS extraBedPrice_total , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) ) AS extraBedPrice_infants_total , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) ) AS extraBedPrice_children_total , ( CASE WHEN r.maximumGuests = 1 THEN ( ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) WHEN r.maximumGuests >= 2 THEN ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) ) - ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) END ) AS fullPrice_discount FROM stayDateTable sd CROSS JOIN @tmpHotelId tmp_h INNER JOIN hotels (NOLOCK) h ON h.hotelID = tmp_h.hotelId INNER JOIN rooms (NOLOCK) r ON r.hotelID = h.hotelID AND r.hotelID = tmp_h.hotelId AND r.ghostRoom = tmp_h.ghostRoom AND r.isDeleted = 0 OUTER APPLY ( SELECT rpd_sub.basePrice, rpd_sub.singlePrice, rpd_sub.extraBedPrice, rpd_sub.minimumStay, rpd_sub.maximumStay FROM price (NOLOCK) rpd_sub WHERE rpd_sub.roomID = r.roomID AND rpd_sub.roomRateDate = sd.stayDate ) rpd OUTER APPLY ( SELECT TOP 1 sc_sub.hotelID, sc_sub.percentuale, sc_sub.giorni FROM sconti (NOLOCK) sc_sub WHERE sc_sub.hotelID = tmp_h.hotelID AND sc_sub.datainizio <= sd.stayDate AND sc_sub.datafine >= sd.stayDate AND sc_sub.giorni < @numeroGiorni AND sc_sub.bbcard = 0 ORDER BY CASE WHEN sc_sub.giorni = 0 THEN 999 ELSE sc_sub.giorni END DESC ) sc ) SELECT c.hotelId , h.idstruttura , h.tipostruttura , cast(h.tipo as nvarchar) as tipo , r.roomID , r.roomIdentifier , r.bathroomInRoom , r.bathroomPrivate , r.bathroomShared , r.maximumGuests , CASE WHEN MAX(r.maximumGuests) OVER (PARTITION BY c.hotelID) <= @numeroOspiti AND cast(h.tipo as nvarchar) IN ('CV', 'AP') THEN 1000 - r.maximumGuests ELSE r.maximumGuests END AS orderMaximumGuests , r.guestsIncludedWithBasePrice , r.breakfastIncluded , r.ghostRoom , r.numberBedRooms , r.roomCount as n_camere , ISNULL(h.pagamento_cc, 0) as pagamento_cc , ISNULL(h.pagamento_fiducia, 0) as pagamento_fiducia , ISNULL(h.pagamento_paypal, 0) as pagamento_paypal , ISNULL(h.pagamento_caparra_cc, 0) as pagamento_caparra_cc , ISNULL(h.pagamento_caparra_satispay, 0) as pagamento_caparra_satispay , ISNULL(h.pagamento_banca, 0) as pagamento_banca , ISNULL(h.pagamento_anticipato_paypal, 0) as pagamento_anticipato_paypal , ISNULL(h.pagamento_anticipato_banca, 0) as pagamento_anticipato_banca , ISNULL(h.pagamento_anticipato_cc, 0) as pagamento_anticipato_cc , ISNULL(h.pagamento_anticipato_satispay, 0) as pagamento_anticipato_satispay , ISNULL(h.pagamento_anticipato_giorni, 0) as pagamento_anticipato_giorni , 1 AS flagTariffaNonRimborsabileGiorni , 0 AS limitazionigiorni , 0 AS limitazionigiornifuturi , ISNULL(h.bambinoMassima1, 0) as bambinoMassima1 , ISNULL(h.bambinoPercentuale1, 0) as bambinoPercentuale1 , ISNULL(h.bambinoMassima2, 0) as bambinoMassima2 , ISNULL(h.bambinoPercentuale2, 0) as bambinoPercentuale2 , 1 AS available , r.roomCount AS n_camere_libere , 0 AS sospeso , 1 AS soggiornominimo , 30 AS soggiornomassimo , 0 AS closedonarrival , 0 AS closedondeparture , 0 AS closedOnArrivalDeparture , 0 AS bloccato , SUM(c.singlePrice_discount) AS singlePrice_discount , SUM(c.basePrice_discount) AS basePrice_discount , SUM(c.extraBedPrice_discount) AS extraBedPrice_discount , SUM(c.extraBedPrice_infants_discount) AS extraBedPrice_infants_discount , SUM(c.extraBedPrice_children_discount) AS extraBedPrice_children_discount , SUM(c.singlePrice_total) AS singlePrice_total , SUM(c.basePrice_total) AS basePrice_total , SUM(c.extraBedPrice_total) AS extraBedPrice_total , SUM(c.extraBedPrice_infants_total) AS extraBedPrice_infants_total , SUM(c.extraBedPrice_children_total) AS extraBedPrice_children_total , SUM(c.fullPrice_discount) AS fullPrice_discount FROM calendario c INNER JOIN studioscivoletto.dbo.hotels (NOLOCK) h ON h.hotelID = c.hotelID INNER JOIN studioscivoletto.dbo.rooms (NOLOCK) r ON r.hotelID = c.hotelID AND r.roomID = c.roomID GROUP BY c.hotelId , h.idstruttura , h.tipostruttura , h.tipo , r.roomID , r.roomIdentifier , r.bathroomInRoom , r.bathroomPrivate , r.bathroomShared , r.maximumGuests , r.guestsIncludedWithBasePrice , r.breakfastIncluded , r.ghostRoom , r.numberBedRooms , r.roomCount , h.pagamento_cc , h.pagamento_fiducia , h.pagamento_paypal , h.pagamento_caparra_cc , h.pagamento_caparra_satispay , h.pagamento_banca , h.pagamento_anticipato_paypal , h.pagamento_anticipato_banca , h.pagamento_anticipato_cc , h.pagamento_anticipato_satispay , h.pagamento_anticipato_giorni , h.bambinoMassima1 , h.bambinoPercentuale1 , h.bambinoMassima2 , h.bambinoPercentuale2 ORDER BY c.hotelid ASC, available DESC, orderMaximumGuests ASC, fullPrice_discount ASC;

StackTrace

coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor126.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor125.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'. at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.r.a(|SQLServer|6.0.0.1282|:1059) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(|SQLServer|6.0.0.1282|:526) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(|SQLServer|6.0.0.1282|:2703) at macromedia.jdbc.sqlserver.base.BasePreparedStatement.execute(|SQLServer|6.0.0.1282|) at macromedia.jdbc.sqlserver.base.fg.$fr$execute(|SQLServer|6.0.0.1282|:525) at macromedia.jdbc.sqlserver.base.fg.execute(|SQLServer|6.0.0.1282|) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1680) at coldfusion.sql.Executive.executeQuery(Executive.java:1406) at coldfusion.sql.Executive.executeQuery(Executive.java:1336) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) ... 100 more

Suppressed

array[empty]

TagContext

array

struct
COLUMN	0
ID	CFQUERY
LINE	3782
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3782)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	462
RAW_TRACE	at cfListaStrutture2ecfc60855799$func_GETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:462)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	6920
RAW_TRACE	at cfListaStrutture2ecfc60855799$funcGETPOCHESTRUTTURE.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6920)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	295
RAW_TRACE	at cflista_struttura_query2ecfm411963857._factor9(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:295)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURA_QUERY
LINE	288
RAW_TRACE	at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:288)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE	CFML

struct
COLUMN	0
ID	CFINCLUDE
LINE	2
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_LISTA_STRUTTURE_UR
LINE	1
RAW_TRACE	at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE	\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	1103
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(\|SQLServer\|6.0.0.1282\|:1103)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	980
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:980)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1124
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:1124)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	193
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(\|SQLServer\|6.0.0.1282\|:193)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1153
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.rZ(\|SQLServer\|6.0.0.1282\|:1153)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4126
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.a(\|SQLServer\|6.0.0.1282\|:4126)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1059
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.r.a(\|SQLServer\|6.0.0.1282\|:1059)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	4275
RAW_TRACE	at macromedia.jdbc.sqlserver.tds.s.c(\|SQLServer\|6.0.0.1282\|:4275)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2035
RAW_TRACE	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(\|SQLServer\|6.0.0.1282\|:2035)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	632
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.cK(\|SQLServer\|6.0.0.1282\|:632)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2699
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.G(\|SQLServer\|6.0.0.1282\|:2699)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	526
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.G(\|SQLServer\|6.0.0.1282\|:526)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2508
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nT(\|SQLServer\|6.0.0.1282\|:2508)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	1358
RAW_TRACE	at macromedia.jdbc.sqlserver.base.gr.nM(\|SQLServer\|6.0.0.1282\|:1358)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	CF_\|SQLSERVER\|6.0.0
LINE	2703
RAW_TRACE	at macromedia.jdbc.sqlserver.base.BasePreparedStatement.$fr$execute(\|SQLServer\|6.0.0.1282\|:2703)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

struct
COLUMN	0
ID	??
LINE	525
RAW_TRACE	at macromedia.jdbc.sqlserver.base.fg.$fr$execute(\|SQLServer\|6.0.0.1282\|:525)
TEMPLATE	\|SQLServer\|6.0.0.1282\|
TYPE	CFML

Type

Database

queryError

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'WITH'.

where

(param 1) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_smallint'] , (param 2) = [type='IN', class='java.lang.Integer', value='1', sqltype='cf_sql_tinyint'] , (param 3) = [type='IN', class='java.lang.Boolean', value='false', sqltype='cf_sql_bit'] , (param 4) = [type='IN', class='java.sql.Date', value='2026-03-12', sqltype='cf_sql_date'] , (param 5) = [type='IN', class='java.sql.Date', value='2026-03-13', sqltype='cf_sql_date'] , (param 6) = [type='IN', class='java.sql.Date', value='2026-03-12', sqltype='cf_sql_date'] , (param 7) = [type='IN', class='java.sql.Date', value='2026-03-12', sqltype='cf_sql_date']