ERROR!

An error occurred!

Action: home:main.faq
Error: Incorrect syntax near '.'.
Type: database
Details:
exception
Catch
Entries: 18
additional
Struct (ordered)
SQL
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.4382
DriverName
stringMicrosoft JDBC Driver 13.2 for SQL Server
DriverVersion
string13.2.1.0
Datasource
stringweb_retailmonitor
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.4382
DriverName
stringMicrosoft JDBC Driver 13.2 for SQL Server
DriverVersion
string13.2.1.0
Datasource
stringweb_retailmonitor
DataSource
stringweb_retailmonitor
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near '.'.
NativeErrorCode
number102
queryError
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
Sql
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Incorrect syntax near '.'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:278) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1788) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:975) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:869) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7825) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4828) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:321) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:253) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:2229) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:298) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:227) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2142) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at model.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:72) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:829) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at model.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:11) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2142) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at global.views.templates.retailmonitor.faqpage_cfm$cf$1w8m.call(/global/views/templates/retailmonitor/faqpage.cfm:6) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at one_cfc$cf.udfCallc(/framework/one.cfc:1984) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at one_cfc$cf.udfCall9(/framework/one.cfc:1409) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at home.views.main.faq_cfm$cf$1w8j.call(/home/views/main/faq.cfm:7) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at one_cfc$cf.udfCallc(/framework/one.cfc:1984) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at one_cfc$cf.udfCall6(/framework/one.cfc:915) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2123) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:479) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:214) at lucee.runtime.listener.ModernAppListener.onRequest(ModernAppListener.java:102) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:718) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
Rows: 10 (showing top 5)
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number227
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:227)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number37
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string70: <br> 71: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;queryString&nbsp;&amp;=&nbsp;&quot;order&nbsp;by&nbsp;r.[listorder];&quot;;<br> <b>72: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;qTemp&nbsp;=&nbsp;queryService.execute(sql=querystring).getResult();</b><br> 73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;qTemp;<br> 74: &nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string70: 71: queryString &= "order by r.[listorder];"; 72: var qTemp = queryService.execute(sql=querystring).getResult(); 73: return qTemp; 74: }
column
number0
id
string??
line
number72
Raw_Trace
stringmodel.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:72)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\model\services\custom\faqservice.cfc
type
stringcfml
4
Struct
codePrintHTML
string9: &nbsp;&nbsp;&nbsp;public&nbsp;array&nbsp;function&nbsp;arrFAQOverview(string&nbsp;subSystem='')&nbsp;{<br> 10: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;result&nbsp;=&nbsp;[];<br> <b>11: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;findRecords&nbsp;=&nbsp;getRecords(subSystem=arguments.subSystem);</b><br> 12: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;(var&nbsp;elem&nbsp;in&nbsp;findRecords)&nbsp;{<br> 13: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;addElem&nbsp;=&nbsp;{&nbsp;'id'=elem.id,&nbsp;'title'=elem.title,&nbsp;'description'=elem.description,&nbsp;'isActive'=elem.isActive,&nbsp;'listorder'=elem.listorder&nbsp;};<br>
codePrintPlain
string9: public array function arrFAQOverview(string subSystem='') { 10: var result = []; 11: var findRecords = getRecords(subSystem=arguments.subSystem); 12: for (var elem in findRecords) { 13: var addElem = { 'id'=elem.id, 'title'=elem.title, 'description'=elem.description, 'isActive'=elem.isActive, 'listorder'=elem.listorder };
column
number0
id
string??
line
number11
Raw_Trace
stringmodel.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:11)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\model\services\custom\faqservice.cfc
type
stringcfml
5
Struct
codePrintHTML
string4: &nbsp;&nbsp;&nbsp;local.config&nbsp;=&nbsp;getBeanFactory().getBean('config');<br> 5: &nbsp;&nbsp;&nbsp;local.faqService&nbsp;=&nbsp;getBeanFactory().getBean('faqService');<br> <b>6: &nbsp;&nbsp;&nbsp;local.faqArray&nbsp;=&nbsp;local.faqService.arrFAQOverview(subSystem=local.subFolder);</b><br> 7: &nbsp;&nbsp;&nbsp;local.varQueryString&nbsp;=&nbsp;'?recipient='&amp;local.config.inretailInfo.panteiaMail;<br> 8: &nbsp;&nbsp;&nbsp;if&nbsp;(session.auth.isLoggedIn&nbsp;and&nbsp;(!isNull(rc.currentUser.getFullName())&nbsp;or&nbsp;rc.currentUser.getFullName()&nbsp;!=&nbsp;''))&nbsp;{<br>
codePrintPlain
string4: local.config = getBeanFactory().getBean('config'); 5: local.faqService = getBeanFactory().getBean('faqService'); 6: local.faqArray = local.faqService.arrFAQOverview(subSystem=local.subFolder); 7: local.varQueryString = '?recipient='&local.config.inretailInfo.panteiaMail; 8: if (session.auth.isLoggedIn and (!isNull(rc.currentUser.getFullName()) or rc.currentUser.getFullName() != '')) {
column
number0
id
string??
line
number6
Raw_Trace
stringglobal.views.templates.retailmonitor.faqpage_cfm$cf$1w8m.call(/global/views/templates/retailmonitor/faqpage.cfm:6)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\global\views\templates\retailmonitor\faqpage.cfm
type
stringcfml
type
stringdatabase
where
string
DataSource
stringweb_retailmonitor
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near '.'.
name
stringonRequest
NativeErrorCode
number102
queryError
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string15.00.4382
DriverName
stringMicrosoft JDBC Driver 13.2 for SQL Server
DriverVersion
string13.2.1.0
Datasource
stringweb_retailmonitor
DataSource
stringweb_retailmonitor
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near '.'.
NativeErrorCode
number102
queryError
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
Sql
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Incorrect syntax near '.'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:278) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1788) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:975) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:869) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7825) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4828) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:321) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:253) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:2229) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:298) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:227) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2142) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at model.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:72) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:829) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at model.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:11) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2142) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at global.views.templates.retailmonitor.faqpage_cfm$cf$1w8m.call(/global/views/templates/retailmonitor/faqpage.cfm:6) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at one_cfc$cf.udfCallc(/framework/one.cfc:1984) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at one_cfc$cf.udfCall9(/framework/one.cfc:1409) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at home.views.main.faq_cfm$cf$1w8j.call(/home/views/main/faq.cfm:7) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at one_cfc$cf.udfCallc(/framework/one.cfc:1984) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at one_cfc$cf.udfCall6(/framework/one.cfc:915) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2123) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:479) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:214) at lucee.runtime.listener.ModernAppListener.onRequest(ModernAppListener.java:102) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:718) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
Rows: 10 (showing top 5)
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number227
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:227)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number37
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string70: <br> 71: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;queryString&nbsp;&amp;=&nbsp;&quot;order&nbsp;by&nbsp;r.[listorder];&quot;;<br> <b>72: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;qTemp&nbsp;=&nbsp;queryService.execute(sql=querystring).getResult();</b><br> 73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;qTemp;<br> 74: &nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string70: 71: queryString &= "order by r.[listorder];"; 72: var qTemp = queryService.execute(sql=querystring).getResult(); 73: return qTemp; 74: }
column
number0
id
string??
line
number72
Raw_Trace
stringmodel.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:72)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\model\services\custom\faqservice.cfc
type
stringcfml
4
Struct
codePrintHTML
string9: &nbsp;&nbsp;&nbsp;public&nbsp;array&nbsp;function&nbsp;arrFAQOverview(string&nbsp;subSystem='')&nbsp;{<br> 10: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;result&nbsp;=&nbsp;[];<br> <b>11: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;findRecords&nbsp;=&nbsp;getRecords(subSystem=arguments.subSystem);</b><br> 12: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;(var&nbsp;elem&nbsp;in&nbsp;findRecords)&nbsp;{<br> 13: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;addElem&nbsp;=&nbsp;{&nbsp;'id'=elem.id,&nbsp;'title'=elem.title,&nbsp;'description'=elem.description,&nbsp;'isActive'=elem.isActive,&nbsp;'listorder'=elem.listorder&nbsp;};<br>
codePrintPlain
string9: public array function arrFAQOverview(string subSystem='') { 10: var result = []; 11: var findRecords = getRecords(subSystem=arguments.subSystem); 12: for (var elem in findRecords) { 13: var addElem = { 'id'=elem.id, 'title'=elem.title, 'description'=elem.description, 'isActive'=elem.isActive, 'listorder'=elem.listorder };
column
number0
id
string??
line
number11
Raw_Trace
stringmodel.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:11)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\model\services\custom\faqservice.cfc
type
stringcfml
5
Struct
codePrintHTML
string4: &nbsp;&nbsp;&nbsp;local.config&nbsp;=&nbsp;getBeanFactory().getBean('config');<br> 5: &nbsp;&nbsp;&nbsp;local.faqService&nbsp;=&nbsp;getBeanFactory().getBean('faqService');<br> <b>6: &nbsp;&nbsp;&nbsp;local.faqArray&nbsp;=&nbsp;local.faqService.arrFAQOverview(subSystem=local.subFolder);</b><br> 7: &nbsp;&nbsp;&nbsp;local.varQueryString&nbsp;=&nbsp;'?recipient='&amp;local.config.inretailInfo.panteiaMail;<br> 8: &nbsp;&nbsp;&nbsp;if&nbsp;(session.auth.isLoggedIn&nbsp;and&nbsp;(!isNull(rc.currentUser.getFullName())&nbsp;or&nbsp;rc.currentUser.getFullName()&nbsp;!=&nbsp;''))&nbsp;{<br>
codePrintPlain
string4: local.config = getBeanFactory().getBean('config'); 5: local.faqService = getBeanFactory().getBean('faqService'); 6: local.faqArray = local.faqService.arrFAQOverview(subSystem=local.subFolder); 7: local.varQueryString = '?recipient='&local.config.inretailInfo.panteiaMail; 8: if (session.auth.isLoggedIn and (!isNull(rc.currentUser.getFullName()) or rc.currentUser.getFullName() != '')) {
column
number0
id
string??
line
number6
Raw_Trace
stringglobal.views.templates.retailmonitor.faqpage_cfm$cf$1w8m.call(/global/views/templates/retailmonitor/faqpage.cfm:6)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\global\views\templates\retailmonitor\faqpage.cfm
type
stringcfml
type
stringdatabase
where
string
Sql
stringwith overviewFaq as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [faq] where [isActive] = 1) , .well-known as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], '.well-known' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%.well-known%' ) , home as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'home' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%home%' ) , registered as (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], 'registered' as [subsystem], [listorder] from [overviewFaq] where [subsystem] like '%registered%' ) , allFaqs as ( select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [.well-known] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [home] union select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [listorder] from [registered] ) select r.[id], r.[title], r.[listorder], f.[description], r.[isActive], r.[listorder] , case when r.[.well-known] is not null then 1 else 0 end as [.well-known] , case when r.[home] is not null then 1 else 0 end as [home] , case when r.[registered] is not null then 1 else 0 end as [registered] from (select [id], [ormVersion], [isActive], [createDate], [createdBy] , [updateDate], [updatedBy], [title], [subsystem], [subsystem] as [newValue], [listorder] from [allFaqs] ) result pivot(max([newValue]) for [subsystem] in ([.well-known], [home], [registered] ) ) r inner join [faq] f on f.[id] = r.[id] where r.[home] is not null order by r.[listorder];
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Incorrect syntax near '.'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:278) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1788) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:975) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:869) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7825) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4828) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:321) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:253) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:2229) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:298) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:227) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at org.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2142) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at model.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:72) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:829) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at model.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:11) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:214) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:695) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2142) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:858) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:2105) at global.views.templates.retailmonitor.faqpage_cfm$cf$1w8m.call(/global/views/templates/retailmonitor/faqpage.cfm:6) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at one_cfc$cf.udfCallc(/framework/one.cfc:1984) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at one_cfc$cf.udfCall9(/framework/one.cfc:1409) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at home.views.main.faq_cfm$cf$1w8j.call(/home/views/main/faq.cfm:7) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1088) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at one_cfc$cf.udfCallc(/framework/one.cfc:1984) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:811) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:773) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:2075) at one_cfc$cf.udfCall6(/framework/one.cfc:915) at one_cfc$cf.udfCall(/framework/one.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2123) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:479) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:214) at lucee.runtime.listener.ModernAppListener.onRequest(ModernAppListener.java:102) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:718) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
Rows: 10 (showing top 5)
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number227
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:227)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number37
Raw_Trace
stringorg.lucee.cfml.query_cfc$cf.udfCall(/org/lucee/cfml/Query.cfc:37)
template
string/org/lucee/cfml/Query.cfc
type
stringcfml
3
Struct
codePrintHTML
string70: <br> 71: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;queryString&nbsp;&amp;=&nbsp;&quot;order&nbsp;by&nbsp;r.[listorder];&quot;;<br> <b>72: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;qTemp&nbsp;=&nbsp;queryService.execute(sql=querystring).getResult();</b><br> 73: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;qTemp;<br> 74: &nbsp;&nbsp;&nbsp;}<br>
codePrintPlain
string70: 71: queryString &= "order by r.[listorder];"; 72: var qTemp = queryService.execute(sql=querystring).getResult(); 73: return qTemp; 74: }
column
number0
id
string??
line
number72
Raw_Trace
stringmodel.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:72)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\model\services\custom\faqservice.cfc
type
stringcfml
4
Struct
codePrintHTML
string9: &nbsp;&nbsp;&nbsp;public&nbsp;array&nbsp;function&nbsp;arrFAQOverview(string&nbsp;subSystem='')&nbsp;{<br> 10: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;result&nbsp;=&nbsp;[];<br> <b>11: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;findRecords&nbsp;=&nbsp;getRecords(subSystem=arguments.subSystem);</b><br> 12: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for&nbsp;(var&nbsp;elem&nbsp;in&nbsp;findRecords)&nbsp;{<br> 13: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;addElem&nbsp;=&nbsp;{&nbsp;'id'=elem.id,&nbsp;'title'=elem.title,&nbsp;'description'=elem.description,&nbsp;'isActive'=elem.isActive,&nbsp;'listorder'=elem.listorder&nbsp;};<br>
codePrintPlain
string9: public array function arrFAQOverview(string subSystem='') { 10: var result = []; 11: var findRecords = getRecords(subSystem=arguments.subSystem); 12: for (var elem in findRecords) { 13: var addElem = { 'id'=elem.id, 'title'=elem.title, 'description'=elem.description, 'isActive'=elem.isActive, 'listorder'=elem.listorder };
column
number0
id
string??
line
number11
Raw_Trace
stringmodel.services.custom.faqservice_cfc$cf$1vsx.udfCall(/model/services/custom/faqservice.cfc:11)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\model\services\custom\faqservice.cfc
type
stringcfml
5
Struct
codePrintHTML
string4: &nbsp;&nbsp;&nbsp;local.config&nbsp;=&nbsp;getBeanFactory().getBean('config');<br> 5: &nbsp;&nbsp;&nbsp;local.faqService&nbsp;=&nbsp;getBeanFactory().getBean('faqService');<br> <b>6: &nbsp;&nbsp;&nbsp;local.faqArray&nbsp;=&nbsp;local.faqService.arrFAQOverview(subSystem=local.subFolder);</b><br> 7: &nbsp;&nbsp;&nbsp;local.varQueryString&nbsp;=&nbsp;'?recipient='&amp;local.config.inretailInfo.panteiaMail;<br> 8: &nbsp;&nbsp;&nbsp;if&nbsp;(session.auth.isLoggedIn&nbsp;and&nbsp;(!isNull(rc.currentUser.getFullName())&nbsp;or&nbsp;rc.currentUser.getFullName()&nbsp;!=&nbsp;''))&nbsp;{<br>
codePrintPlain
string4: local.config = getBeanFactory().getBean('config'); 5: local.faqService = getBeanFactory().getBean('faqService'); 6: local.faqArray = local.faqService.arrFAQOverview(subSystem=local.subFolder); 7: local.varQueryString = '?recipient='&local.config.inretailInfo.panteiaMail; 8: if (session.auth.isLoggedIn and (!isNull(rc.currentUser.getFullName()) or rc.currentUser.getFullName() != '')) {
column
number0
id
string??
line
number6
Raw_Trace
stringglobal.views.templates.retailmonitor.faqpage_cfm$cf$1w8m.call(/global/views/templates/retailmonitor/faqpage.cfm:6)
template
stringD:\internetsites\onderzoek.nl\dev\inretailwonen\webroot\global\views\templates\retailmonitor\faqpage.cfm
type
stringcfml
type
stringdatabase
where
string