ERRORDATA | Catch Entries: 15 | additional | Struct (ordered) | SQL | string | DECLARE @intPage int = 1;
DECLARE @intPageSize int = 36
SELECT *,
overall_count = COUNT(*) OVER()
FROM (
SELECT DISTINCT
a.intAccessoryID
,a.vchrName
,vchrMPN
,vchrImageThumb
,vchrImageMed
,vchrImageLarge
,vchrImageXLarge
,vchrImageONVehicle
,vchrPDFFile
,a.blnActive
,a.intCategoryID
,intLayer
,intDisplayType
,a.intBrandID
,( SELECT [decPrice] FROM [Accessories].[dbo].[tbl_Rough_Price_CA] WHERE [vchrPartnumber]
= a.vchrMPN ) AS decPrice
,blnStock
,a.txtDescription
,a.txtDescription2
,a.txtDescription2 as features
,a.txtDescription3 as techInfo
,a.txtDescription4 as kitComponents
,b.intID as brandID
,b.vchrName as brandName
,b.vchrImage as brandImage
,b.vchrThumbnail AS brandLogo
,a.vchrWeight
FROM tbl_accessories a
INNER JOIN tbl_brand b WITH (NOLOCK) ON a.intBrandID = b.intID
INNER JOIN tbl_websitebrand wb WITH (NOLOCK) ON wb.intBrandID = a.intBrandID
WHERE a.blnActive = 1
AND a.intAccessoryID = 25838
) a
ORDER BY brandName ASC, vchrName ASC
OFFSET (@intPage - 1) * @intPageSize ROWS
FETCH NEXT @intPageSize ROWS ONLY |
|
| DataSource | | Detail | string | available columns are [INTACCESSORYID, VCHRNAME, VCHRMPN, VCHRIMAGETHUMB, VCHRIMAGEMED, VCHRIMAGELARGE, VCHRIMAGEXLARGE, VCHRIMAGEONVEHICLE, VCHRPDFFILE, BLNACTIVE, INTCATEGORYID, INTLAYER, INTDISPLAYTYPE, INTBRANDID, DECPRICE, BLNSTOCK, TXTDESCRIPTION, TXTDESCRIPTION2, FEATURES, TECHINFO, KITCOMPONENTS, BRANDID, BRANDNAME, BRANDIMAGE, BRANDLOGO, VCHRWEIGHT, OVERALL_COUNT] |
| ErrorCode | | Extended_Info | | ExtendedInfo | | Message | string | Column [DECMSRP] not found in query |
| NativeErrorCode | | queryError | string | DECLARE @intPage int = 1;
DECLARE @intPageSize int = 36
SELECT *,
overall_count = COUNT(*) OVER()
FROM (
SELECT DISTINCT
a.intAccessoryID
,a.vchrName
,vchrMPN
,vchrImageThumb
,vchrImageMed
,vchrImageLarge
,vchrImageXLarge
,vchrImageONVehicle
,vchrPDFFile
,a.blnActive
,a.intCategoryID
,intLayer
,intDisplayType
,a.intBrandID
,( SELECT [decPrice] FROM [Accessories].[dbo].[tbl_Rough_Price_CA] WHERE [vchrPartnumber]
= a.vchrMPN ) AS decPrice
,blnStock
,a.txtDescription
,a.txtDescription2
,a.txtDescription2 as features
,a.txtDescription3 as techInfo
,a.txtDescription4 as kitComponents
,b.intID as brandID
,b.vchrName as brandName
,b.vchrImage as brandImage
,b.vchrThumbnail AS brandLogo
,a.vchrWeight
FROM tbl_accessories a
INNER JOIN tbl_brand b WITH (NOLOCK) ON a.intBrandID = b.intID
INNER JOIN tbl_websitebrand wb WITH (NOLOCK) ON wb.intBrandID = a.intBrandID
WHERE a.blnActive = 1
AND a.intAccessoryID = 25838
) a
ORDER BY brandName ASC, vchrName ASC
OFFSET (@intPage - 1) * @intPageSize ROWS
FETCH NEXT @intPageSize ROWS ONLY |
| Sql | string | DECLARE @intPage int = 1;
DECLARE @intPageSize int = 36
SELECT *,
overall_count = COUNT(*) OVER()
FROM (
SELECT DISTINCT
a.intAccessoryID
,a.vchrName
,vchrMPN
,vchrImageThumb
,vchrImageMed
,vchrImageLarge
,vchrImageXLarge
,vchrImageONVehicle
,vchrPDFFile
,a.blnActive
,a.intCategoryID
,intLayer
,intDisplayType
,a.intBrandID
,( SELECT [decPrice] FROM [Accessories].[dbo].[tbl_Rough_Price_CA] WHERE [vchrPartnumber]
= a.vchrMPN ) AS decPrice
,blnStock
,a.txtDescription
,a.txtDescription2
,a.txtDescription2 as features
,a.txtDescription3 as techInfo
,a.txtDescription4 as kitComponents
,b.intID as brandID
,b.vchrName as brandName
,b.vchrImage as brandImage
,b.vchrThumbnail AS brandLogo
,a.vchrWeight
FROM tbl_accessories a
INNER JOIN tbl_brand b WITH (NOLOCK) ON a.intBrandID = b.intID
INNER JOIN tbl_websitebrand wb WITH (NOLOCK) ON wb.intBrandID = a.intBrandID
WHERE a.blnActive = 1
AND a.intAccessoryID = 25838
) a
ORDER BY brandName ASC, vchrName ASC
OFFSET (@intPage - 1) * @intPageSize ROWS
FETCH NEXT @intPageSize ROWS ONLY |
| SQLState | | StackTrace | string | lucee.runtime.exp.DatabaseException: Column [DECMSRP] not found in query
at lucee.runtime.type.QueryImpl.getAt(QueryImpl.java:1151)
at lucee.runtime.type.QueryImpl.get(QueryImpl.java:2062)
at lucee.runtime.util.VariableUtilImpl.get(VariableUtilImpl.java:279)
at lucee.runtime.PageContextImpl.us(PageContextImpl.java:1238)
at accessories.includes.accessory.information_cfm$cf.call(/accessories/includes/accessory/information.cfm:7)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at accessory_cfm$cf.call(/accessory.cfm:92)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1046)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:213)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
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:482)
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.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:424)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
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 | 5: if(accessory.decPrice neq '') {<br>
6: cartPrice = accessory.decPrice;<br>
<b>7: } else if (accessory.decMSRP neq '' AND accessory.decMSRP neq 0) {</b><br>
8: cartPrice = accessory.decMSRP;<br>
9: } <br>
|
| codePrintPlain | string | 5: if(accessory.decPrice neq '') {
6: cartPrice = accessory.decPrice;
7: } else if (accessory.decMSRP neq '' AND accessory.decMSRP neq 0) {
8: cartPrice = accessory.decMSRP;
9: }
|
| column | | id | | line | | Raw_Trace | string | accessories.includes.accessory.information_cfm$cf.call(/accessories/includes/accessory/information.cfm:7) |
| template | string | D:\WebSites\willystire.ca\accessories\includes\accessory\information.cfm |
| type | |
| 2 | Struct | codePrintHTML | string | 90: <div class="column medium-6"><br>
91: <!--- Title and Brand ---><br>
<b>92: <cfinclude template="/accessories/includes/accessory/information.cfm" /></b><br>
93: <!--- Information ---><br>
94: <!--- Vehicle ---><br>
|
| codePrintPlain | string | 90: <div class="column medium-6">
91: <!--- Title and Brand --->
92: <cfinclude template="/accessories/includes/accessory/information.cfm" />
93: <!--- Information --->
94: <!--- Vehicle --->
|
| column | | id | | line | | Raw_Trace | string | accessory_cfm$cf.call(/accessory.cfm:92) |
| template | string | D:\WebSites\willystire.ca\accessory.cfm |
| type | |
|
| type | | where | |
|