Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | SELECT
DISTINCT cc1.id,cc1.deptid
,cc1.iscrosslisted,cc2.deptid AS cdeptid,cc2.courseno AS ccourseno,cc2.title AS crosstitle, cc2.courseDesc AS COURSEDESCXLIST, cc2.deleted AS cDeleted,
cd.name AS cdeptname,
d.name AS deptname
FROM cat_courses cc1
LEFT OUTER JOIN cat_courses cc2 ON cc1.crossid = cc2.id
LEFT OUTER JOIN cat_depts cd ON cc2.deptid = cd.id
LEFT OUTER JOIN cat_subheads cs ON cc1.subheadid = cs.id
INNER JOIN cat_depts d ON cc1.deptid = d.id
WHERE
(cc1.deleted = ''
OR cc1.deleted = {ts '1900-01-01 00:00:00'}
OR cc1.deleted IS NULL)
AND cc1.courseno <> ''
AND (cc1.isWI = 1)
ORDER BY deptname |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 4.0 for SQL Server |
| | DriverVersion | | | Datasource | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | The text data type cannot be selected as DISTINCT because it is not comparable. |
|
| NativeErrorCode | |
| queryError | | string | SELECT
DISTINCT cc1.id,cc1.deptid
,cc1.iscrosslisted,cc2.deptid AS cdeptid,cc2.courseno AS ccourseno,cc2.title AS crosstitle, cc2.courseDesc AS COURSEDESCXLIST, cc2.deleted AS cDeleted,
cd.name AS cdeptname,
d.name AS deptname
FROM cat_courses cc1
LEFT OUTER JOIN cat_courses cc2 ON cc1.crossid = cc2.id
LEFT OUTER JOIN cat_depts cd ON cc2.deptid = cd.id
LEFT OUTER JOIN cat_subheads cs ON cc1.subheadid = cs.id
INNER JOIN cat_depts d ON cc1.deptid = d.id
WHERE
(cc1.deleted = ''
OR cc1.deleted = {ts '1900-01-01 00:00:00'}
OR cc1.deleted IS NULL)
AND cc1.courseno <> ''
AND (cc1.isWI = 1)
ORDER BY deptname |
|
| Sql | | string | SELECT
DISTINCT cc1.id,cc1.deptid
,cc1.iscrosslisted,cc2.deptid AS cdeptid,cc2.courseno AS ccourseno,cc2.title AS crosstitle, cc2.courseDesc AS COURSEDESCXLIST, cc2.deleted AS cDeleted,
cd.name AS cdeptname,
d.name AS deptname
FROM cat_courses cc1
LEFT OUTER JOIN cat_courses cc2 ON cc1.crossid = cc2.id
LEFT OUTER JOIN cat_depts cd ON cc2.deptid = cd.id
LEFT OUTER JOIN cat_subheads cs ON cc1.subheadid = cs.id
INNER JOIN cat_depts d ON cc1.deptid = d.id
WHERE
(cc1.deleted = ''
OR cc1.deleted = {ts '1900-01-01 00:00:00'}
OR cc1.deleted IS NULL)
AND cc1.courseno <> ''
AND (cc1.isWI = 1)
ORDER BY deptname |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: The text data type cannot be selected as DISTINCT because it is not comparable.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
at com.seefusion.StatementImpl.execute(StatementImpl.java:311)
at com.seefusion.Statement7.execute(Statement7.java:7)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:296)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1127)
at lucee.runtime.tag.Query._doEndTag(Query.java:694)
at lucee.runtime.tag.Query.doEndTag(Query.java:559)
at applications.catalogue.cfc.courses_cfc$cf.udfCall(/applications/catalogue/cfc/Courses.cfc:38)
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:715)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1996)
at academics.special_cfm$cf.call(/academics/special.cfm:87)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1050)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:944)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:925)
at application_cfc$cf.udfCall(/application.cfc:81)
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:715)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2029)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2731)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2718)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2689)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1155)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1112)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
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:761)
at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:388)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 36: <cfquery name="getRows" datasource="#dsn#" maxrows="#maxrows#"><br>
37: #preserveSingleQuotes(badasssql)#<br>
<b>38: </cfquery></b><br>
39: <br>
40: <cfcatch type="any"><br>
|
| | codePrintPlain | | string | 36: <cfquery name="getRows" datasource="#dsn#" maxrows="#maxrows#">
37: #preserveSingleQuotes(badasssql)#
38: </cfquery>
39:
40: <cfcatch type="any">
|
| | column | | | id | | | line | | | Raw_Trace | | string | applications.catalogue.cfc.courses_cfc$cf.udfCall(/applications/catalogue/cfc/Courses.cfc:38) |
| | template | | string | \\canopus-fs.hamilton.edu\hamiltonweb\www\applications\catalogue\cfc\Courses.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 85: <cfscript><br>
86: courseObj = createObject('component','applications.catalogue.CFC.courses');<br>
<b>87: deptQry = courseObj.getAll('','DISTINCT cc1.id,cc1.deptid',"cc1.isWI = 1",'deptname');</b><br>
88: </cfscript><br>
89: <br>
|
| | codePrintPlain | | string | 85: <cfscript>
86: courseObj = createObject('component','applications.catalogue.CFC.courses');
87: deptQry = courseObj.getAll('','DISTINCT cc1.id,cc1.deptid',"cc1.isWI = 1",'deptname');
88: </cfscript>
89:
|
| | column | | | id | | | line | | | Raw_Trace | | string | academics.special_cfm$cf.call(/academics/special.cfm:87) |
| | template | | string | \\canopus-fs.hamilton.edu\hamiltonweb\www\academics\special.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 79: <cfargument name = "targetPage" type="String" required=true/><br>
80: <cftry><br>
<b>81: <cfinclude template="#Arguments.targetPage#" /></b><br>
82: <cfcatch type="missinginclude"><br>
83: <cflocation url="/404" addtoken="false" /><br>
|
| | codePrintPlain | | string | 79: <cfargument name = "targetPage" type="String" required=true/>
80: <cftry>
81: <cfinclude template="#Arguments.targetPage#" />
82: <cfcatch type="missinginclude">
83: <cflocation url="/404" addtoken="false" />
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/application.cfc:81) |
| | template | | string | \\canopus-fs.hamilton.edu\hamiltonweb\www\application.cfc |
| | type | |
|
|
| type | |
| where | |