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:320)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135)
at lucee.runtime.tag.Query._doEndTag(Query.java:700)
at lucee.runtime.tag.Query.doEndTag(Query.java:566)
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:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1775)
at academics.special_cfm$cf.call(/academics/special.cfm:87)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929)
at application_cfc$cf.udfCall(/application.cfc:74)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:698)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161)
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 com.seefusion.Filter.doFilter(Filter.java:109)
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.valves.RemoteIpValve.invoke(RemoteIpValve.java:685)
at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
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 | 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 | 72: <cfargument name = "targetPage" type="String" required=true/><br>
73: <cftry><br>
<b>74: <cfinclude template="#Arguments.targetPage#" /></b><br>
75: <cfcatch type="missinginclude"><br>
76: <cflocation url="/404" addtoken="false" /><br>
|
| | codePrintPlain | | string | 72: <cfargument name = "targetPage" type="String" required=true/>
73: <cftry>
74: <cfinclude template="#Arguments.targetPage#" />
75: <cfcatch type="missinginclude">
76: <cflocation url="/404" addtoken="false" />
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/application.cfc:74) |
| | template | | string | \\canopus-fs.hamilton.edu\hamiltonweb\www\application.cfc |
| | type | |
|
|
| type | |
| where | |