Scope Arguments
exception1
Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT 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
string
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcolumn [BITISSUSPENDED] not found in query, columns are [INTUSERLOGINID,STR_FIRST_NAME,STR_LAST_NAME,STR_DENTAL_SPECIALITY_EN,STR_DENTAL_SPECIALITY_FR]
NativeErrorCode
number-1
queryError
stringSELECT 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
stringSELECT 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
string
StackTrace
stringlucee.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
string282: &lt;td class=&quot;registerdetail_values&quot;&gt; &lt;cfif variables.strLangCode EQ 'en'&gt;#qRegisteredUserDetails.str_dental_speciality_en#&lt;cfelse&gt;#qRegisteredUserDetails.str_dental_speciality_fr#&lt;/cfif&gt; &lt;/td&gt;<br> 283: &lt;td class=&quot;registerdetail_values&quot;&gt;<br> <b>284: &lt;cfif val(qRegisteredUserDetails.bitIsSuspended) eq 1&gt;</b><br> 285: #getMyString(objXml,'labaelsuspended')#<br> 286: &lt;cfelseif val(qRegisteredUserDetails.bitIsSuspended) eq 0&gt;<br>
codePrintPlain
string282: <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
number0
id
string??
line
number284
Raw_Trace
stringcustom.register.register_cfm$cf.call(/custom/register/register.cfm:284)
template
stringD:\rcdc.ca_stage\Custom\register\register.cfm
type
stringcfml
2
Struct
codePrintHTML
string66: &lt;cfif objCMS.isCustomPage EQ 1&gt;<br> 67: &lt;cfset Variables.custom_page_name = &quot;custom/&quot; &amp; objCMS.customPageName&gt;<br> <b>68: &lt;cfinclude template=&quot;#Variables.custom_page_name#&quot;&gt;</b><br> 69: &lt;cfelse&gt;<br> 70: &lt;cfif Variables.page_content NEQ &quot;&quot;&gt;<br>
codePrintPlain
string66: <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
number0
id
string??
line
number68
Raw_Trace
stringindex_cfm$cf.call(/index.cfm:68)
template
stringD:\rcdc.ca_stage\index.cfm
type
stringcfml
type
stringdatabase
where
string
22
string