Catch
Entries: 15 |
| additional | | Struct (ordered) | | SQL | | string | SELECT sp.id,sp.FirstName,sp.LastName,sp.Title,sp.Company
FROM ScheduleToSpeaker s
INNER JOIN Speakers sp
ON s.SpeakerID = sp.ID
WHERE s.ScheduleID =
Order by sp.FirstName |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | | string | besthomebuildingpractices |
|
|
| DataSource | | string | besthomebuildingpractices |
|
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | Incorrect syntax near the keyword 'Order'. |
|
| NativeErrorCode | |
| queryError | | string | SELECT sp.id,sp.FirstName,sp.LastName,sp.Title,sp.Company
FROM ScheduleToSpeaker s
INNER JOIN Speakers sp
ON s.SpeakerID = sp.ID
WHERE s.ScheduleID =
Order by sp.FirstName |
|
| Sql | | string | SELECT sp.id,sp.FirstName,sp.LastName,sp.Title,sp.Company
FROM ScheduleToSpeaker s
INNER JOIN Speakers sp
ON s.SpeakerID = sp.ID
WHERE s.ScheduleID =
Order by sp.FirstName |
|
| SQLState | |
| StackTrace | | string | lucee.runtime.exp.DatabaseException: Incorrect syntax near the keyword 'Order'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:946)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:840)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7748)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4410)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:813)
at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:298)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125)
at lucee.runtime.tag.Query._doEndTag(Query.java:692)
at lucee.runtime.tag.Query.doEndTag(Query.java:557)
at sschedule.qry_getspeakers_cfm$cf.call(/sschedule/qry_getSpeakers.cfm:18)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993)
at sschedule.index_cfm$cf.call(/sschedule/index.cfm:25)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993)
at index_cfm$cf.call(/index.cfm:11)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:1004)
at lucee.runtime.tag.CFTag.doInclude(CFTag.java:333)
at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:259)
at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:193)
at _404_cfm$cf.call_000003(/404.cfm:192)
at _404_cfm$cf.call(/404.cfm:188)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:215)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52)
at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:431)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:905)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
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 | 16: <br>
17: Order by sp.FirstName<br>
<b>18: </cfquery></b><br>
|
| | codePrintPlain | | string | 16:
17: Order by sp.FirstName
18: </cfquery>
|
| | column | | | id | | | line | | | Raw_Trace | | string | sschedule.qry_getspeakers_cfm$cf.call(/sschedule/qry_getSpeakers.cfm:18) |
| | template | | string | D:\CustomDomains\besthomebuildingpractices\htdocs\sschedule\qry_getSpeakers.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 23: <cfinclude template="/common/qry_getpage.cfm"><br>
24: <cfinclude template="qry_getScheduleDetail.cfm"><br>
<b>25: <cfinclude template="qry_getSpeakers.cfm"></b><br>
26: <br>
27: <cfinclude template="dsp_scheduleDetail.cfm"><br>
|
| | codePrintPlain | | string | 23: <cfinclude template="/common/qry_getpage.cfm">
24: <cfinclude template="qry_getScheduleDetail.cfm">
25: <cfinclude template="qry_getSpeakers.cfm">
26:
27: <cfinclude template="dsp_scheduleDetail.cfm">
|
| | column | | | id | | | line | | | Raw_Trace | | string | sschedule.index_cfm$cf.call(/sschedule/index.cfm:25) |
| | template | | string | D:\CustomDomains\besthomebuildingpractices\htdocs\sschedule\index.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 9: <cfswitch expression="#section#"><br>
10: <cfcase value="home,about,speakers,schedule,venue,faq,register,sponsors,hba,testimonials"><br>
<b>11: <cfinclude template="s#section#/index.cfm"></b><br>
12: </cfcase><br>
13: </cfswitch><br>
|
| | codePrintPlain | | string | 9: <cfswitch expression="#section#">
10: <cfcase value="home,about,speakers,schedule,venue,faq,register,sponsors,hba,testimonials">
11: <cfinclude template="s#section#/index.cfm">
12: </cfcase>
13: </cfswitch>
|
| | column | | | id | | | line | | | Raw_Trace | | string | index_cfm$cf.call(/index.cfm:11) |
| | template | | string | D:\CustomDomains\besthomebuildingpractices\htdocs\index.cfm |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 190: <cfset ID = ListFirst(ID, ".")><br>
191: <cfset ID = ListLast(ID, "-")><br>
<b>192: <cf_index method="#theSection#.#theSubsection#" ID="#id#"></b><br>
193: <cfabort><br>
194: </cfif><br>
|
| | codePrintPlain | | string | 190: <cfset ID = ListFirst(ID, ".")>
191: <cfset ID = ListLast(ID, "-")>
192: <cf_index method="#theSection#.#theSubsection#" ID="#id#">
193: <cfabort>
194: </cfif>
|
| | column | | | id | | | line | | | Raw_Trace | | string | _404_cfm$cf.call_000003(/404.cfm:192) |
| | template | | string | D:\CustomDomains\besthomebuildingpractices\htdocs\404.cfm |
| | type | |
| | 5 | | Struct | | codePrintHTML | | string | 186: <br>
187: <br>
<b>188: <cfif theSection EQ 'Schedule' and theSubSection EQ "ScheduleDetail" AND sectionlist CONTAINS theSection></b><br>
189: <cfset ID = ListLast(scriptName, "/")><br>
190: <cfset ID = ListFirst(ID, ".")><br>
|
| | codePrintPlain | | string | 186:
187:
188: <cfif theSection EQ 'Schedule' and theSubSection EQ "ScheduleDetail" AND sectionlist CONTAINS theSection>
189: <cfset ID = ListLast(scriptName, "/")>
190: <cfset ID = ListFirst(ID, ".")>
|
| | column | | | id | | | line | | | Raw_Trace | | string | _404_cfm$cf.call(/404.cfm:188) |
| | template | | string | D:\CustomDomains\besthomebuildingpractices\htdocs\404.cfm |
| | type | |
|
|
| type | |
| where | |