exception | 1 | Catch Entries: 15 | additional | Struct (ordered) | SQL | string | SELECT
UP.intUserLoginId AS intUserLoginId
, UP.strFirstName AS str_first_name
, UP.strLastName AS str_last_name
, DS.dentalSpecialityEn AS str_dental_speciality_en
, DS.dentalSpecialityfr AS str_dental_speciality_fr
FROM
tblUserLoginSpecialities ULS
LEFT JOIN tblDentalSpeciality DS ON ULS.intDentalSpecialityId = DS.dentalSpecialityId
INNER JOIN tblUserLoginProfile UP ON UP.intUserLoginId = ULS.intUserLoginId
INNER JOIN tblUserLogin UL ON UL.intUserLoginId = UP.intUserLoginId
INNER JOIN tblMemberGroup MG ON UP.intMemberGroupId = MG.intMemberGroupId
LEFT JOIN tblRegisterCustom RC ON UP.intUserLoginId = RC.intUserLoginId
WHERE 1 = 1 AND MG.strMemberGroupCode in ('FF','FC','FX','LF','H','MC','MF','LM','FEC','FEF','CFE') AND UL.bitIsSuspended=0
ORDER BY UP.strLastName |
|
| DataSource | | Detail | | ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | column [BITISSUSPENDED] not found in query, columns are [INTUSERLOGINID,STR_FIRST_NAME,STR_LAST_NAME,STR_DENTAL_SPECIALITY_EN,STR_DENTAL_SPECIALITY_FR] |
| NativeErrorCode | | queryError | string | SELECT
UP.intUserLoginId AS intUserLoginId
, UP.strFirstName AS str_first_name
, UP.strLastName AS str_last_name
, DS.dentalSpecialityEn AS str_dental_speciality_en
, DS.dentalSpecialityfr AS str_dental_speciality_fr
FROM
tblUserLoginSpecialities ULS
LEFT JOIN tblDentalSpeciality DS ON ULS.intDentalSpecialityId = DS.dentalSpecialityId
INNER JOIN tblUserLoginProfile UP ON UP.intUserLoginId = ULS.intUserLoginId
INNER JOIN tblUserLogin UL ON UL.intUserLoginId = UP.intUserLoginId
INNER JOIN tblMemberGroup MG ON UP.intMemberGroupId = MG.intMemberGroupId
LEFT JOIN tblRegisterCustom RC ON UP.intUserLoginId = RC.intUserLoginId
WHERE 1 = 1 AND MG.strMemberGroupCode in ('FF','FC','FX','LF','H','MC','MF','LM','FEC','FEF','CFE') AND UL.bitIsSuspended=0
ORDER BY UP.strLastName |
| Sql | string | SELECT
UP.intUserLoginId AS intUserLoginId
, UP.strFirstName AS str_first_name
, UP.strLastName AS str_last_name
, DS.dentalSpecialityEn AS str_dental_speciality_en
, DS.dentalSpecialityfr AS str_dental_speciality_fr
FROM
tblUserLoginSpecialities ULS
LEFT JOIN tblDentalSpeciality DS ON ULS.intDentalSpecialityId = DS.dentalSpecialityId
INNER JOIN tblUserLoginProfile UP ON UP.intUserLoginId = ULS.intUserLoginId
INNER JOIN tblUserLogin UL ON UL.intUserLoginId = UP.intUserLoginId
INNER JOIN tblMemberGroup MG ON UP.intMemberGroupId = MG.intMemberGroupId
LEFT JOIN tblRegisterCustom RC ON UP.intUserLoginId = RC.intUserLoginId
WHERE 1 = 1 AND MG.strMemberGroupCode in ('FF','FC','FX','LF','H','MC','MF','LM','FEC','FEF','CFE') AND UL.bitIsSuspended=0
ORDER BY UP.strLastName |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: column [BITISSUSPENDED] not found in query, columns are [INTUSERLOGINID,STR_FIRST_NAME,STR_LAST_NAME,STR_DENTAL_SPECIALITY_EN,STR_DENTAL_SPECIALITY_FR]
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:922)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:1880)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:263)
at lucee.runtime.PageContextImpl.get(PageContextImpl.java:1516)
at custom.register.register_cfm$cf.call(/custom/register/register.cfm:284)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
at index_cfm$cf.call(/index.cfm:68)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427)
at lucee.runtime.engine.Request.exe(Request.java:44)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1090)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038)
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:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
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:486)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
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 | 282: <td class="registerdetail_values"> <cfif variables.strLangCode EQ 'en'>#qRegisteredUserDetails.str_dental_speciality_en#<cfelse>#qRegisteredUserDetails.str_dental_speciality_fr#</cfif> </td><br>
283: <td class="registerdetail_values"><br>
<b>284: <cfif val(qRegisteredUserDetails.bitIsSuspended) eq 1></b><br>
285: #getMyString(objXml,'labaelsuspended')#<br>
286: <cfelseif val(qRegisteredUserDetails.bitIsSuspended) eq 0><br>
|
| codePrintPlain | string | 282: <td class="registerdetail_values"> <cfif variables.strLangCode EQ 'en'>#qRegisteredUserDetails.str_dental_speciality_en#<cfelse>#qRegisteredUserDetails.str_dental_speciality_fr#</cfif> </td>
283: <td class="registerdetail_values">
284: <cfif val(qRegisteredUserDetails.bitIsSuspended) eq 1>
285: #getMyString(objXml,'labaelsuspended')#
286: <cfelseif val(qRegisteredUserDetails.bitIsSuspended) eq 0>
|
| column | | id | | line | | Raw_Trace | string | custom.register.register_cfm$cf.call(/custom/register/register.cfm:284) |
| template | string | D:\rcdc.ca_stage\Custom\register\register.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 66: <cfif objCMS.isCustomPage EQ 1><br>
67: <cfset Variables.custom_page_name = "custom/" & objCMS.customPageName><br>
<b>68: <cfinclude template="#Variables.custom_page_name#"></b><br>
69: <cfelse><br>
70: <cfif Variables.page_content NEQ ""><br>
|
| codePrintPlain | string | 66: <cfif objCMS.isCustomPage EQ 1>
67: <cfset Variables.custom_page_name = "custom/" & objCMS.customPageName>
68: <cfinclude template="#Variables.custom_page_name#">
69: <cfelse>
70: <cfif Variables.page_content NEQ "">
|
| column | | id | | line | | Raw_Trace | string | index_cfm$cf.call(/index.cfm:68) |
| template | string | D:\rcdc.ca_stage\index.cfm |
| type | |
|
| type | | where | |
|