Struct Entries: 15 | additional | Struct (ordered) | SQL | string | SELECT ed.id as employeeID,ed.first_name,ed.last_name,ed.email,ed.phone1,ed.phone2,ed.address1,ed.address2,ed.city,
ed.state,ed.country,ed.zip,ed.badge_no,ed.permissions_level,ed.location,ed.department,ed.position,
ed.employee_status,ed.email_status,ed.approval_email, reset_email,reset_phone1, reset_password, employment_start_date,
ed.positional_supervisor, ed.is_deleted
FROM employee_details ed
WHERE ed.site_id=8
ORDER BY ed.is_deleted, TRIM(ed.last_name) ASC |
|
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | column [BACKGROUND_COLOR] not found in query, columns are [EMPLOYEEID,FIRST_NAME,LAST_NAME,EMAIL,PHONE1,PHONE2,ADDRESS1,ADDRESS2,CITY,STATE,COUNTRY,ZIP,BADGE_NO,PERMISSIONS_LEVEL,LOCATION,DEPARTMENT,POSITION,EMPLOYEE_STATUS,EMAIL_STATUS,APPROVAL_EMAIL,RESET_EMAIL,RESET_PHONE1,RESET_PASSWORD,EMPLOYMENT_START_DATE,POSITIONAL_SUPERVISOR,IS_DELETED] |
| NativeErrorCode | | queryError | string | SELECT ed.id as employeeID,ed.first_name,ed.last_name,ed.email,ed.phone1,ed.phone2,ed.address1,ed.address2,ed.city,
ed.state,ed.country,ed.zip,ed.badge_no,ed.permissions_level,ed.location,ed.department,ed.position,
ed.employee_status,ed.email_status,ed.approval_email, reset_email,reset_phone1, reset_password, employment_start_date,
ed.positional_supervisor, ed.is_deleted
FROM employee_details ed
WHERE ed.site_id=8
ORDER BY ed.is_deleted, TRIM(ed.last_name) ASC |
| Sql | string | SELECT ed.id as employeeID,ed.first_name,ed.last_name,ed.email,ed.phone1,ed.phone2,ed.address1,ed.address2,ed.city,
ed.state,ed.country,ed.zip,ed.badge_no,ed.permissions_level,ed.location,ed.department,ed.position,
ed.employee_status,ed.email_status,ed.approval_email, reset_email,reset_phone1, reset_password, employment_start_date,
ed.positional_supervisor, ed.is_deleted
FROM employee_details ed
WHERE ed.site_id=8
ORDER BY ed.is_deleted, TRIM(ed.last_name) ASC |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: column [BACKGROUND_COLOR] not found in query, columns are [EMPLOYEEID,FIRST_NAME,LAST_NAME,EMAIL,PHONE1,PHONE2,ADDRESS1,ADDRESS2,CITY,STATE,COUNTRY,ZIP,BADGE_NO,PERMISSIONS_LEVEL,LOCATION,DEPARTMENT,POSITION,EMPLOYEE_STATUS,EMAIL_STATUS,APPROVAL_EMAIL,RESET_EMAIL,RESET_PHONE1,RESET_PASSWORD,EMPLOYMENT_START_DATE,POSITIONAL_SUPERVISOR,IS_DELETED]
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1140)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2048)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:278)
at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1539)
at layouts.sitelayouts.wrapper_header_cfm$cf.call(/layouts/siteLayouts/wrapper_header.cfm:65)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
at layouts.sitelayouts.wrapper_cfm$cf.call(/layouts/siteLayouts/wrapper.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
at layouts.productdetailsview.productdetails_cfm$cf$3a.call(/layouts/productdetailsview/productDetails.cfm:1)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1034)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:926)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:907)
at org.corfield.framework_cfc$cf.udfCall7(/org/corfield/framework.cfc:1513)
at org.corfield.framework_cfc$cf.udfCall(/org/corfield/framework.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:785)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1747)
at org.corfield.framework_cfc$cf.udfCall2(/org/corfield/framework.cfc:556)
at org.corfield.framework_cfc$cf.udfCall(/org/corfield/framework.cfc)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:106)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:344)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:217)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:684)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:572)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1911)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:437)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2460)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2450)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2421)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1179)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1125)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:479)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
|
| TagContext | Array | 1 | Struct | codePrintHTML | string | 63: <br>
64: <cfoutput><br>
<b>65: <body class="d-flex flex-column min-vh-100" style="background-color: :#APPLICATION.layoutDetails .background_color#;"></b><br>
66: </cfoutput><br>
67: <br>
|
| codePrintPlain | string | 63:
64: <cfoutput>
65: <body class="d-flex flex-column min-vh-100" style="background-color: :#APPLICATION.layoutDetails .background_color#;">
66: </cfoutput>
67:
|
| column | | id | | line | | Raw_Trace | string | layouts.sitelayouts.wrapper_header_cfm$cf.call(/layouts/siteLayouts/wrapper_header.cfm:65) |
| template | string | C:\sites\websam\site\layouts\siteLayouts\wrapper_header.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | <b>1: <cfinclude template="/layouts/siteLayouts/wrapper_header.cfm"> </b><br>
2: <br>
3: <!--- <body class="d-flex flex-column min-vh-100"> ---><br>
|
| codePrintPlain | string | 1: <cfinclude template="/layouts/siteLayouts/wrapper_header.cfm">
2:
3: <!--- <body class="d-flex flex-column min-vh-100"> --->
|
| column | | id | | line | | Raw_Trace | string | layouts.sitelayouts.wrapper_cfm$cf.call(/layouts/siteLayouts/wrapper.cfm:1) |
| template | string | C:\sites\websam\site\layouts\siteLayouts\wrapper.cfm |
| type | |
| 3 | Struct | codePrintHTML | string | <b>1: <cfinclude template="/layouts/siteLayouts/wrapper.cfm"></b><br>
2: <!--- <cfoutput><br>
3: <!DOCTYPE html><br>
|
| codePrintPlain | string | 1: <cfinclude template="/layouts/siteLayouts/wrapper.cfm">
2: <!--- <cfoutput>
3: <!DOCTYPE html>
|
| column | | id | | line | | Raw_Trace | string | layouts.productdetailsview.productdetails_cfm$cf$3a.call(/layouts/productdetailsview/productDetails.cfm:1) |
| template | string | C:\sites\websam\site\layouts\productDetailsView\productDetails.cfm |
| type | |
| 4 | Struct | codePrintHTML | string | 1511: </cfif><br>
1512: <br>
<b>1513: <cfsavecontent variable='response'><cfinclude template="#layoutPath#"/></cfsavecontent></b><br>
1514: <br>
1515: <cfreturn response /><br>
|
| codePrintPlain | string | 1511: </cfif>
1512:
1513: <cfsavecontent variable='response'><cfinclude template="#layoutPath#"/></cfsavecontent>
1514:
1515: <cfreturn response />
|
| column | | id | | line | | Raw_Trace | string | org.corfield.framework_cfc$cf.udfCall7(/org/corfield/framework.cfc:1513) |
| template | string | C:\sites\websam\site\org\corfield\framework.cfc |
| type | |
| 5 | Struct | codePrintHTML | string | 554: break;<br>
555: }<br>
<b>556: out = internalLayout( request.layouts[i], out );</b><br>
557: }<br>
558: writeOutput( out );<br>
|
| codePrintPlain | string | 554: break;
555: }
556: out = internalLayout( request.layouts[i], out );
557: }
558: writeOutput( out );
|
| column | | id | | line | | Raw_Trace | string | org.corfield.framework_cfc$cf.udfCall2(/org/corfield/framework.cfc:556) |
| template | string | C:\sites\websam\site\org\corfield\framework.cfc |
| type | |
|
| type | | where | |
|