Catch
Entries: 15

additional

Struct (ordered)

SQL

string

DECLARE @intPage int = 218; DECLARE @intPageSize int = 36 DECLARE @blnUseRetailOnly bit = 0 SELECT @blnUseRetailOnly = blnUseRetailOnly From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK) Where intConfigID = 11623 SELECT *, overall_count = COUNT(*) OVER() FROM ( SELECT DISTINCT ws.vchrPartNumber as partNumber ,ws.intWheelSpecID ,wi.intWheelImageID ,wi.intWheelID ,wi.vchrName AS wheelName ,wi.intlugs AS intLugs ,wi.vchrImage ,wi.intFinishID ,Coalesce(( SELECT s.intSortOrder FROM tbl_ConfigWheelSort s WITH (NOLOCK) WHERE s.intWheelID = wi.intWheelID AND s.intConfigid = 11623 ),999) AS SortOrder ,Coalesce((bC.intSortOrder),300) as BrandSortOrder ,b.vchrName AS BrandName ,b.intId AS brandID ,wi.vchrImageLarge ,ws.decDiameter ,ws.decWidth ,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize ,ws.vchrOffset ,ws.vchrBoltPat1 ,ws.vchrBoltPat4 ,f.vchrName AS vchrFinish ,ws.intOffSet ,(CASE WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0) WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0) ELSE Coalesce(ws.monPrice,0) END ) AS monDisplayPrice ,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_Inventory] i WHERE i.vchrPartNumber = ws.[vchrPartNumber] AND i.intBrandID = ws.intBrandID ) ,-1)AS [intQTY] ,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice] WHERE [intBrandID] = ws.intBrandID AND [vchrPartNumber] = ws.[vchrPartNumber] AND GetDate() Between [dtDateFrom] AND [dtDateTo] ),0.00) as decPromoPrice ,Coalesce(r.decSalePrice,0.00) As decSalePrice ,w.dtDateCreated FROM tbl_wheelimage wi WITH (NOLOCK) INNER JOIN tbl_wheel w WITH (NOLOCK) ON w.intWheelID = wi.intWheelID INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = w.intBrandID AND b.blnActive = 1 AND b.intTypeID = 1 INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID AND bc.intConfigID = 11623 INNER JOIN tbl_finish f WITH (NOLOCK) ON f.intFinishID = wi.intFinishID INNER JOIN tbl_wheelSpec ws WITH (NOLOCK) ON ws.intWheelImageID = wi.intWheelImageID LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber AND r.intConfigID = 11623 AND r.intBrandID = b.intID WHERE w.blnActive = 1 AND wi.intWheelViewID IN (1,4) AND NOT EXISTS(SELECT intWheelID FROM tbl_Exclude_WheelConfig WHERE intWheelID = w.intWheelID AND intConfigID = 11623) ) a ORDER BY intQTY DESC,intOffSet DESC, SortOrder, vchrSize, BrandSortOrder, BrandName, wheelName,vchrFinish OFFSET (@intPage - 1) * @intPageSize ROWS FETCH NEXT @intPageSize ROWS ONLY

DatabaseName

string

Microsoft SQL Server

DatabaseVersion

string

14.00.3281

DriverName

string

Microsoft JDBC Driver 4.0 for SQL Server

DriverVersion

string

4.0.2206.100

Datasource

string

configurator

DataSource

string

configurator

Detail

string

ErrorCode

string

0

Extended_Info

string

ExtendedInfo

string

Message

string

Transaction (Process ID 167) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

NativeErrorCode

number

1205

queryError

string

DECLARE @intPage int = 218; DECLARE @intPageSize int = 36 DECLARE @blnUseRetailOnly bit = 0 SELECT @blnUseRetailOnly = blnUseRetailOnly From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK) Where intConfigID = 11623 SELECT *, overall_count = COUNT(*) OVER() FROM ( SELECT DISTINCT ws.vchrPartNumber as partNumber ,ws.intWheelSpecID ,wi.intWheelImageID ,wi.intWheelID ,wi.vchrName AS wheelName ,wi.intlugs AS intLugs ,wi.vchrImage ,wi.intFinishID ,Coalesce(( SELECT s.intSortOrder FROM tbl_ConfigWheelSort s WITH (NOLOCK) WHERE s.intWheelID = wi.intWheelID AND s.intConfigid = 11623 ),999) AS SortOrder ,Coalesce((bC.intSortOrder),300) as BrandSortOrder ,b.vchrName AS BrandName ,b.intId AS brandID ,wi.vchrImageLarge ,ws.decDiameter ,ws.decWidth ,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize ,ws.vchrOffset ,ws.vchrBoltPat1 ,ws.vchrBoltPat4 ,f.vchrName AS vchrFinish ,ws.intOffSet ,(CASE WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0) WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0) ELSE Coalesce(ws.monPrice,0) END ) AS monDisplayPrice ,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_Inventory] i WHERE i.vchrPartNumber = ws.[vchrPartNumber] AND i.intBrandID = ws.intBrandID ) ,-1)AS [intQTY] ,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice] WHERE [intBrandID] = ws.intBrandID AND [vchrPartNumber] = ws.[vchrPartNumber] AND GetDate() Between [dtDateFrom] AND [dtDateTo] ),0.00) as decPromoPrice ,Coalesce(r.decSalePrice,0.00) As decSalePrice ,w.dtDateCreated FROM tbl_wheelimage wi WITH (NOLOCK) INNER JOIN tbl_wheel w WITH (NOLOCK) ON w.intWheelID = wi.intWheelID INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = w.intBrandID AND b.blnActive = 1 AND b.intTypeID = 1 INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID AND bc.intConfigID = 11623 INNER JOIN tbl_finish f WITH (NOLOCK) ON f.intFinishID = wi.intFinishID INNER JOIN tbl_wheelSpec ws WITH (NOLOCK) ON ws.intWheelImageID = wi.intWheelImageID LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber AND r.intConfigID = 11623 AND r.intBrandID = b.intID WHERE w.blnActive = 1 AND wi.intWheelViewID IN (1,4) AND NOT EXISTS(SELECT intWheelID FROM tbl_Exclude_WheelConfig WHERE intWheelID = w.intWheelID AND intConfigID = 11623) ) a ORDER BY intQTY DESC,intOffSet DESC, SortOrder, vchrSize, BrandSortOrder, BrandName, wheelName,vchrFinish OFFSET (@intPage - 1) * @intPageSize ROWS FETCH NEXT @intPageSize ROWS ONLY

Sql

string

DECLARE @intPage int = 218; DECLARE @intPageSize int = 36 DECLARE @blnUseRetailOnly bit = 0 SELECT @blnUseRetailOnly = blnUseRetailOnly From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK) Where intConfigID = 11623 SELECT *, overall_count = COUNT(*) OVER() FROM ( SELECT DISTINCT ws.vchrPartNumber as partNumber ,ws.intWheelSpecID ,wi.intWheelImageID ,wi.intWheelID ,wi.vchrName AS wheelName ,wi.intlugs AS intLugs ,wi.vchrImage ,wi.intFinishID ,Coalesce(( SELECT s.intSortOrder FROM tbl_ConfigWheelSort s WITH (NOLOCK) WHERE s.intWheelID = wi.intWheelID AND s.intConfigid = 11623 ),999) AS SortOrder ,Coalesce((bC.intSortOrder),300) as BrandSortOrder ,b.vchrName AS BrandName ,b.intId AS brandID ,wi.vchrImageLarge ,ws.decDiameter ,ws.decWidth ,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize ,ws.vchrOffset ,ws.vchrBoltPat1 ,ws.vchrBoltPat4 ,f.vchrName AS vchrFinish ,ws.intOffSet ,(CASE WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0) WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0) ELSE Coalesce(ws.monPrice,0) END ) AS monDisplayPrice ,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_Inventory] i WHERE i.vchrPartNumber = ws.[vchrPartNumber] AND i.intBrandID = ws.intBrandID ) ,-1)AS [intQTY] ,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice] WHERE [intBrandID] = ws.intBrandID AND [vchrPartNumber] = ws.[vchrPartNumber] AND GetDate() Between [dtDateFrom] AND [dtDateTo] ),0.00) as decPromoPrice ,Coalesce(r.decSalePrice,0.00) As decSalePrice ,w.dtDateCreated FROM tbl_wheelimage wi WITH (NOLOCK) INNER JOIN tbl_wheel w WITH (NOLOCK) ON w.intWheelID = wi.intWheelID INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = w.intBrandID AND b.blnActive = 1 AND b.intTypeID = 1 INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID AND bc.intConfigID = 11623 INNER JOIN tbl_finish f WITH (NOLOCK) ON f.intFinishID = wi.intFinishID INNER JOIN tbl_wheelSpec ws WITH (NOLOCK) ON ws.intWheelImageID = wi.intWheelImageID LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber AND r.intConfigID = 11623 AND r.intBrandID = b.intID WHERE w.blnActive = 1 AND wi.intWheelViewID IN (1,4) AND NOT EXISTS(SELECT intWheelID FROM tbl_Exclude_WheelConfig WHERE intWheelID = w.intWheelID AND intConfigID = 11623) ) a ORDER BY intQTY DESC,intOffSet DESC, SortOrder, vchrSize, BrandSortOrder, BrandName, wheelName,vchrFinish OFFSET (@intPage - 1) * @intPageSize ROWS FETCH NEXT @intPageSize ROWS ONLY

SQLState

string

40001

StackTrace

string

lucee.runtime.exp.DatabaseException: Transaction (Process ID 167) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4853) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1781) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1034) at com.seefusion.ResultSetImpl.next(ResultSetImpl.java:131) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:701) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304) 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 wheels.queries_cfc$cf.udfCall1(/wheels/queries.cfc:316) at wheels.queries_cfc$cf.udfCall(/wheels/queries.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) 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 wheels.default_cfm$cf.call(/wheels/default.cfm:150) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) 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:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.seefusion.Filter.doFilter(Filter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

TagContext

Array

1

Struct

codePrintHTML

string

314: FETCH NEXT @intPageSize ROWS ONLY 315: </CFIF> 316: </cfquery> 317: 318:

codePrintPlain

string

314: FETCH NEXT @intPageSize ROWS ONLY 315: </CFIF> 316: </cfquery> 317: 318:

column

number

0

id

string

??

line

number

316

Raw_Trace

string

wheels.queries_cfc$cf.udfCall1(/wheels/queries.cfc:316)

template

string

D:\WebSites\socalcustomwheels.com\wheels\queries.cfc

type

string

cfml

2

Struct

codePrintHTML

string

148: url.search, 149: isFilter 150: ); 151: } 152:

codePrintPlain

string

148: url.search, 149: isFilter 150: ); 151: } 152:

column

number

0

id

string

??

line

number

150

Raw_Trace

string

wheels.default_cfm$cf.call(/wheels/default.cfm:150)

template

string

D:\WebSites\socalcustomwheels.com\wheels\default.cfm

type

string

cfml

type

string

database

where

string

Struct

BROWSEREXCLUDELIST

string

bot,spider,crawl,jeeves,yahoo,slurp,bing

CRAWLER

boolean

true

ERRORDATA

Catch
Entries: 15

additional

Struct (ordered)

SQL

string

DECLARE @intPage int = 218; DECLARE @intPageSize int = 36 DECLARE @blnUseRetailOnly bit = 0 SELECT @blnUseRetailOnly = blnUseRetailOnly From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK) Where intConfigID = 11623 SELECT *, overall_count = COUNT(*) OVER() FROM ( SELECT DISTINCT ws.vchrPartNumber as partNumber ,ws.intWheelSpecID ,wi.intWheelImageID ,wi.intWheelID ,wi.vchrName AS wheelName ,wi.intlugs AS intLugs ,wi.vchrImage ,wi.intFinishID ,Coalesce(( SELECT s.intSortOrder FROM tbl_ConfigWheelSort s WITH (NOLOCK) WHERE s.intWheelID = wi.intWheelID AND s.intConfigid = 11623 ),999) AS SortOrder ,Coalesce((bC.intSortOrder),300) as BrandSortOrder ,b.vchrName AS BrandName ,b.intId AS brandID ,wi.vchrImageLarge ,ws.decDiameter ,ws.decWidth ,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize ,ws.vchrOffset ,ws.vchrBoltPat1 ,ws.vchrBoltPat4 ,f.vchrName AS vchrFinish ,ws.intOffSet ,(CASE WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0) WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0) ELSE Coalesce(ws.monPrice,0) END ) AS monDisplayPrice ,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_Inventory] i WHERE i.vchrPartNumber = ws.[vchrPartNumber] AND i.intBrandID = ws.intBrandID ) ,-1)AS [intQTY] ,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice] WHERE [intBrandID] = ws.intBrandID AND [vchrPartNumber] = ws.[vchrPartNumber] AND GetDate() Between [dtDateFrom] AND [dtDateTo] ),0.00) as decPromoPrice ,Coalesce(r.decSalePrice,0.00) As decSalePrice ,w.dtDateCreated FROM tbl_wheelimage wi WITH (NOLOCK) INNER JOIN tbl_wheel w WITH (NOLOCK) ON w.intWheelID = wi.intWheelID INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = w.intBrandID AND b.blnActive = 1 AND b.intTypeID = 1 INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID AND bc.intConfigID = 11623 INNER JOIN tbl_finish f WITH (NOLOCK) ON f.intFinishID = wi.intFinishID INNER JOIN tbl_wheelSpec ws WITH (NOLOCK) ON ws.intWheelImageID = wi.intWheelImageID LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber AND r.intConfigID = 11623 AND r.intBrandID = b.intID WHERE w.blnActive = 1 AND wi.intWheelViewID IN (1,4) AND NOT EXISTS(SELECT intWheelID FROM tbl_Exclude_WheelConfig WHERE intWheelID = w.intWheelID AND intConfigID = 11623) ) a ORDER BY intQTY DESC,intOffSet DESC, SortOrder, vchrSize, BrandSortOrder, BrandName, wheelName,vchrFinish OFFSET (@intPage - 1) * @intPageSize ROWS FETCH NEXT @intPageSize ROWS ONLY

DatabaseName

string

Microsoft SQL Server

DatabaseVersion

string

14.00.3281

DriverName

string

Microsoft JDBC Driver 4.0 for SQL Server

DriverVersion

string

4.0.2206.100

Datasource

string

configurator

DataSource

string

configurator

Detail

string

ErrorCode

string

0

Extended_Info

string

ExtendedInfo

string

Message

string

Transaction (Process ID 167) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

NativeErrorCode

number

1205

queryError

string

DECLARE @intPage int = 218; DECLARE @intPageSize int = 36 DECLARE @blnUseRetailOnly bit = 0 SELECT @blnUseRetailOnly = blnUseRetailOnly From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK) Where intConfigID = 11623 SELECT *, overall_count = COUNT(*) OVER() FROM ( SELECT DISTINCT ws.vchrPartNumber as partNumber ,ws.intWheelSpecID ,wi.intWheelImageID ,wi.intWheelID ,wi.vchrName AS wheelName ,wi.intlugs AS intLugs ,wi.vchrImage ,wi.intFinishID ,Coalesce(( SELECT s.intSortOrder FROM tbl_ConfigWheelSort s WITH (NOLOCK) WHERE s.intWheelID = wi.intWheelID AND s.intConfigid = 11623 ),999) AS SortOrder ,Coalesce((bC.intSortOrder),300) as BrandSortOrder ,b.vchrName AS BrandName ,b.intId AS brandID ,wi.vchrImageLarge ,ws.decDiameter ,ws.decWidth ,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize ,ws.vchrOffset ,ws.vchrBoltPat1 ,ws.vchrBoltPat4 ,f.vchrName AS vchrFinish ,ws.intOffSet ,(CASE WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0) WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0) ELSE Coalesce(ws.monPrice,0) END ) AS monDisplayPrice ,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_Inventory] i WHERE i.vchrPartNumber = ws.[vchrPartNumber] AND i.intBrandID = ws.intBrandID ) ,-1)AS [intQTY] ,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice] WHERE [intBrandID] = ws.intBrandID AND [vchrPartNumber] = ws.[vchrPartNumber] AND GetDate() Between [dtDateFrom] AND [dtDateTo] ),0.00) as decPromoPrice ,Coalesce(r.decSalePrice,0.00) As decSalePrice ,w.dtDateCreated FROM tbl_wheelimage wi WITH (NOLOCK) INNER JOIN tbl_wheel w WITH (NOLOCK) ON w.intWheelID = wi.intWheelID INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = w.intBrandID AND b.blnActive = 1 AND b.intTypeID = 1 INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID AND bc.intConfigID = 11623 INNER JOIN tbl_finish f WITH (NOLOCK) ON f.intFinishID = wi.intFinishID INNER JOIN tbl_wheelSpec ws WITH (NOLOCK) ON ws.intWheelImageID = wi.intWheelImageID LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber AND r.intConfigID = 11623 AND r.intBrandID = b.intID WHERE w.blnActive = 1 AND wi.intWheelViewID IN (1,4) AND NOT EXISTS(SELECT intWheelID FROM tbl_Exclude_WheelConfig WHERE intWheelID = w.intWheelID AND intConfigID = 11623) ) a ORDER BY intQTY DESC,intOffSet DESC, SortOrder, vchrSize, BrandSortOrder, BrandName, wheelName,vchrFinish OFFSET (@intPage - 1) * @intPageSize ROWS FETCH NEXT @intPageSize ROWS ONLY

Sql

string

DECLARE @intPage int = 218; DECLARE @intPageSize int = 36 DECLARE @blnUseRetailOnly bit = 0 SELECT @blnUseRetailOnly = blnUseRetailOnly From [icon_master].[dbo].[tbl_configurators] WITH (NOLOCK) Where intConfigID = 11623 SELECT *, overall_count = COUNT(*) OVER() FROM ( SELECT DISTINCT ws.vchrPartNumber as partNumber ,ws.intWheelSpecID ,wi.intWheelImageID ,wi.intWheelID ,wi.vchrName AS wheelName ,wi.intlugs AS intLugs ,wi.vchrImage ,wi.intFinishID ,Coalesce(( SELECT s.intSortOrder FROM tbl_ConfigWheelSort s WITH (NOLOCK) WHERE s.intWheelID = wi.intWheelID AND s.intConfigid = 11623 ),999) AS SortOrder ,Coalesce((bC.intSortOrder),300) as BrandSortOrder ,b.vchrName AS BrandName ,b.intId AS brandID ,wi.vchrImageLarge ,ws.decDiameter ,ws.decWidth ,(Replace(Replace(CAST(ws.decDiameter AS Varchar(20)),'.00',''),'.0','') + 'x' + Replace(Replace(CAST(ws.decWidth AS Varchar(20)),'.00',''),'.0','' )) AS vchrSize ,ws.vchrOffset ,ws.vchrBoltPat1 ,ws.vchrBoltPat4 ,f.vchrName AS vchrFinish ,ws.intOffSet ,(CASE WHEN @blnUseRetailOnly = 1 THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) = 0 AND Coalesce(ws.monMapPrice,0) = 0 THEN Coalesce(ws.monPrice,0) WHEN Coalesce(r.[decRetailPrice],0) >= Coalesce(ws.monMapPrice,0) THEN Coalesce(r.[decRetailPrice],0) WHEN Coalesce(r.[decRetailPrice],0) <= Coalesce(ws.monMapPrice,0) THEN Coalesce(ws.monMapPrice,0) ELSE Coalesce(ws.monPrice,0) END ) AS monDisplayPrice ,Coalesce((SELECT top 1 i.[intQTY] FROM [icon_front].[dbo].[tbl_ICF_Inventory] i WHERE i.vchrPartNumber = ws.[vchrPartNumber] AND i.intBrandID = ws.intBrandID ) ,-1)AS [intQTY] ,Coalesce((SELECT Top 1 [decPrice] FROM [dbo].[tbl_PromoPrice] WHERE [intBrandID] = ws.intBrandID AND [vchrPartNumber] = ws.[vchrPartNumber] AND GetDate() Between [dtDateFrom] AND [dtDateTo] ),0.00) as decPromoPrice ,Coalesce(r.decSalePrice,0.00) As decSalePrice ,w.dtDateCreated FROM tbl_wheelimage wi WITH (NOLOCK) INNER JOIN tbl_wheel w WITH (NOLOCK) ON w.intWheelID = wi.intWheelID INNER JOIN tbl_brand b WITH (NOLOCK) ON b.intID = w.intBrandID AND b.blnActive = 1 AND b.intTypeID = 1 INNER JOIN tbl_brandConfig bc WITH (NOLOCK) ON bc.intBrandID = b.intID AND bc.intConfigID = 11623 INNER JOIN tbl_finish f WITH (NOLOCK) ON f.intFinishID = wi.intFinishID INNER JOIN tbl_wheelSpec ws WITH (NOLOCK) ON ws.intWheelImageID = wi.intWheelImageID LEFT JOIN [dbo].[tbl_RetailTWPNPrice] r on r.vchrManuPartNumber = ws.vchrPartNumber AND r.intConfigID = 11623 AND r.intBrandID = b.intID WHERE w.blnActive = 1 AND wi.intWheelViewID IN (1,4) AND NOT EXISTS(SELECT intWheelID FROM tbl_Exclude_WheelConfig WHERE intWheelID = w.intWheelID AND intConfigID = 11623) ) a ORDER BY intQTY DESC,intOffSet DESC, SortOrder, vchrSize, BrandSortOrder, BrandName, wheelName,vchrFinish OFFSET (@intPage - 1) * @intPageSize ROWS FETCH NEXT @intPageSize ROWS ONLY

SQLState

string

40001

StackTrace

string

lucee.runtime.exp.DatabaseException: Transaction (Process ID 167) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4853) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1781) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1034) at com.seefusion.ResultSetImpl.next(ResultSetImpl.java:131) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:701) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:304) 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 wheels.queries_cfc$cf.udfCall1(/wheels/queries.cfc:316) at wheels.queries_cfc$cf.udfCall(/wheels/queries.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) 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 wheels.default_cfm$cf.call(/wheels/default.cfm:150) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1056) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) 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:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.seefusion.Filter.doFilter(Filter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at com.seefusion.SeeFusionValve.invoke(SeeFusionValve.java:52) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)

TagContext

Array

1

Struct

codePrintHTML

string

314: FETCH NEXT @intPageSize ROWS ONLY 315: </CFIF> 316: </cfquery> 317: 318:

codePrintPlain

string

314: FETCH NEXT @intPageSize ROWS ONLY 315: </CFIF> 316: </cfquery> 317: 318:

column

number

0

id

string

??

line

number

316

Raw_Trace

string

wheels.queries_cfc$cf.udfCall1(/wheels/queries.cfc:316)

template

string

D:\WebSites\socalcustomwheels.com\wheels\queries.cfc

type

string

cfml

2

Struct

codePrintHTML

string

148: url.search, 149: isFilter 150: ); 151: } 152:

codePrintPlain

string

148: url.search, 149: isFilter 150: ); 151: } 152:

column

number

0

id

string

??

line

number

150

Raw_Trace

string

wheels.default_cfm$cf.call(/wheels/default.cfm:150)

template

string

D:\WebSites\socalcustomwheels.com\wheels\default.cfm

type

string

cfml

type

string

database

where

string

ERRORMESS

string

Transaction (Process ID 167) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

item

string

bing

Scope
Entries: 29

boltpat

string

brand

string

cat

string

category

string

construction

string

cta

string

diam

string

diameter

string

finish

string

finishID

string

lugs

string

offset

string

page

string

218

pageSize

string

20

price

string

search

string

searchwheel

string

sizeid

string

sort

string

style

string

13570

tireSize

string

tireSizeRear

string

tireSku

string

tireSpec

string

tireSpecRear

string

tvtypes

string

types

string

wheel

string

0

width

string

Scope Session (Type JEE)

RATELIMIT

Struct

216.73.216.141

Struct

COUNT

number

2

FIRSTHIT

number

1761480933374

sessionid

string

B5B0964A2E14E1B980EF7D93189C531D

STARTED

Date Time (US/Pacific)

{ts '2025-10-26 05:15:34'}

urltoken

string

CFID=6bda61dc-38a6-4a7c-ae23-78f4e22a428e&CFTOKEN=0&jsessionid=B5B0964A2E14E1B980EF7D93189C531D

CGI Scope
Entries: 47

auth_password

string

auth_type

string

auth_user

string

cert_cookie

string

cert_flags

string

cert_issuer

string

cert_keysize

string

cert_secretkeysize

string

cert_serialnumber

string

cert_server_issuer

string

cert_server_subject

string

cert_subject

string

cf_template_path

string

D:\WebSites\socalcustomwheels.com\wheels\default.cfm

content_length

string

0

content_type

string

context_path

string

gateway_interface

string

CGI/1.1

http_accept

string

*/*

http_accept_encoding

string

gzip, br, zstd, deflate

http_accept_language

string

http_connection

string

http_cookie

string

AWSALB=LCiLwokaSGtWWMf6LkXOv2kc08k06onhYHU+W8iXmLkKfo0pAkLeH0n4KuVg60nrYAfZBtTvT/tdxR9GtqTyj1fq/1gN1hiRA420YzoVAIs3QZuwaY2ZC6jIa8B6; AWSALBCORS=LCiLwokaSGtWWMf6LkXOv2kc08k06onhYHU+W8iXmLkKfo0pAkLeH0n4KuVg60nrYAfZBtTvT/tdxR9GtqTyj1fq/1gN1hiRA420YzoVAIs3QZuwaY2ZC6jIa8B6

http_host

string

socalcustomwheels.com

http_referer

string

http_user_agent

string

Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

https

string

off

https_keysize

string

https_secretkeysize

string

https_server_issuer

string

https_server_subject

string

local_addr

string

10.0.2.248

local_host

string

WIN-5D1E8O5OE4B

path_info

string

path_translated

string

D:\WebSites\socalcustomwheels.com\wheels\default.cfm

query_string

string

page=218&style=13570

remote_addr

string

10.0.1.98

remote_host

string

10.0.1.98

remote_user

string

request_method

string

GET

request_url

string

http://socalcustomwheels.com/wheels/default.cfm?page=218&style=13570

script_name

string

/wheels/default.cfm

server_name

string

socalcustomwheels.com

server_port

string

80

server_port_secure

string

0

server_protocol

string

HTTP/1.1

server_software

string

web_server_api

string

Scope
Entries: 69

ACCESSORIESID

number

0

ACCESSORYBRANDID

number

617

ADDTOFOOTER

Public Function addToFooter
source: D:\WebSites\modules\_functions-V2.cfm
adds scripts to the footer

arguments

label	name	required	type	default	hint
	vchrScript	false	any

return type

any

APIKEY

string

YTKCFTMRTFFHQTPVILBRLKYYGGAANCEFLEFPWCWVLWQNPAPRIH

applicationname

string

socalcustomwheels

ARRFONTFAMILY

Array

1

string

Montserrat:wght@100;200;300;400;500;600;700;800;900

ATDCLIENTID

string

RICH_LINE

ATDLOCATIONID

string

439365

ATDPASSWORD

string

qRY6LN63Ue

ATDUSERNAME

string

richlinesthapi

BLOGID

number

3064

CONFIGID

number

11623

CONTACTEMAIL

string

info@socalcustomwheels.com

CONTACTFAX

string

1-949-515-3430

DOWNLOADSPASSWORD

string

socalcustomVIP

DSN

string

configurator

ERRORLOG

Struct

FOOTERSCRIPTS

string

GALLERYID

number

3063

GENERATEACCORDIONGALLERYFILTERS

Public Function generateAccordionGalleryFilters
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intGalleryCategoryID	false	numeric	0
	vchrMakeLabel	false	any	Make
	vchrModelLabel	false	any	Model
	vchrBrandLabel	false	any	Brands
	vchrSearchLabel	false	any	Search
	vchrBrandTypeList	false	any	1

return type

any

GENERATEAPPGUIDEPOPUP

Public Function generateAppGuidePopup
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	redirectToOnClear	false	any		sets the page to redirect the user to when the clear button is clicked
	blnHideMake	false	any	false

return type

any

GENERATECONFIG

Public Function generateConfig
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intConfigID	false	numeric	11623

return type

any

GENERATEFEATUREDWHEELS

Public Function generateFeaturedWheels
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intFeaturedID	true	numeric	null
	blnShowLugs	false	any	true
	blnShowFinish	false	any	true
	blnShowSizes	false	any	true
	blnHoverText	false	any	true
	imageSize	false	any	medium
	blnLinkByWheelImage	false	any	false

return type

any

GENERATEGALLERYMAINIMAGES

Public Function generateGalleryMainImages
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	getGallery	true	query	null

return type

any

GENERATEGALLERYVEHICLETOPSLICK

Public Function generateGalleryVehicleTopSlick
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	GetGallery	true	query	null
	blnShowArrows	false	boolean	true

return type

any

GENERATEINFINITESCROLLGALLERY

Public Function generateInfiniteScrollGallery
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	query	false	any	false
	intGalleryCategoryID	false	any	0
	blnShowExclusiveResults	false	any	false
	intWheelID	false	any	0
	intMaxRows	false	any	36

return type

any

GENERATEINSTAFEED

Public Function generateInstaFeed
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	clientID	true	string
	accessToken	true	string
	imgLimit	false	numeric	9
	imgSize	false	string	low_resolution
	containerClass	false	string
	templateClass	false	string

return type

any

GENERATEMENU

Public Function generateMenu
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intMenuID	false	numeric	0
	vchrType	false	string
	vchrTopUlClass	false	string
	vchrTopUlAttr	false	string
	vchrSubUlClass	false	string
	vchrSubUlAttr	false	string

return type

any

GENERATERFQPOPUP

Public Function generateRFQPopup
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	page	false	string	wheel
	captcha	false	boolean	false

return type

any

GENERATESHARINGTOOLBOX

Public Function generateSharingToolbox
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label

name

required

type

default

hint

return type

any

GENERATESIZESLIST

Public Function generateSizesList
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intWheelID	true	numeric	null

return type

any

GENERATESLIDER

Public Function generateSlider
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intSliderID	true	numeric	null
	blnShowDots	false	any	false
	blnShowArrows	false	any	false

return type

any

GENERATESOCIALLINKSLIST

Public Function generateSocialLinksList
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	vchrOrder	false	any
	vchrLiClass	false	any
	vchrAClass	false	any
	vchrIClass	false	any
	vchrTarget	false	any	_blank

return type

any

GENERATESPECSWDIAMETERTABS

Public Function generateSpecsWdiameterTabs
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intWheelID	true	numeric	null
	vchrClass	false	any

return type

any

GENERATETIREFILTERS

Public Function generateTireFilters
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	blnShowATMT	false	any	true
	blnDisplayActive	false	any	false

return type

any

GENERATEVIEWONVEHICLEPANE

Public Function generateViewOnVehiclePane
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intWheelImageID	false	any	null
	blnUseAppGuide	false	any	true
	blnViewVehicleText	false	any	false
	blnViewVehicleLoadingText	false	any	false

return type

any

GENERATEWHEELFILTERS

Public Function generateWheelFilters
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label

name

required

type

default

hint

return type

any

GENERATEWHEELS

Public Function generateWheels
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	query	true	any	null	query to loop over
	blnShowViewOnVehicleLink	false	any	false
	blnShowDiameters	false	any	false
	blnShowLugs	false	any	false
	blnLinkByWheelImage	false	any	false

return type

any

GENERATEYOUTUBEPLAYLIST

Public Function generateYoutubePlaylist
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	smallColumn	false	numeric	1
	mediumColumn	false	numeric	2

return type

any

GETPAGINATION

Public Function getPagination
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	intMaxRows	true	numeric	null
	totalRecords	true	numeric	null
	page	true	numeric	null
	params	false	string

return type

any

GETPARAMS

Public Function getParams
source: D:\WebSites\modules\_functions-V2.cfm
gets items from the url and puts them into a URL string

arguments

label	name	required	type	default	hint
	paramsList	true	any	null

return type

any

GETSEARCH

Public Function getSearch
source: D:\WebSites\modules\_functions-V2.cfm
send a list of database variables and returns the SQL search string

arguments

label	name	required	type	default	hint
	variableList	true	any	null
	blnShowExclusiveResults	false	any	false	If set to true, then the search must match all of the words
	vchrYearsToColumn	false	any		used for year searched
	vchrYearsFromColumn	false	any		used for year searched

return type

any

GLOBAL

Component (cfc.global)
Only the functions and data members that are accessible from your location are displayed

this

public

getCountry

Public Function getCountry
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label

name

required

type

default

hint

return type

any

getMegamenuItems

Public Function getMegamenuItems
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label	name	required	type	default	hint
	menuItemID	false	numeric	0

return type

any

getMenuItems

Public Function getMenuItems
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label	name	required	type	default	hint
	intMenuID	false	numeric	0
	vchrType	false	string

return type

any

getMenuItemsByClass

Public Function getMenuItemsByClass
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label	name	required	type	default	hint
	className	false	string	0

return type

any

getMenuItemsByOther

Public Function getMenuItemsByOther
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label	name	required	type	default	hint
	menuTitle	false	string	0

return type

any

getWidget

Public Function getWidget
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label	name	required	type	default	hint
	widgetID	false	any	null

return type

any

init

Public Function init
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label

name

required

type

default

hint

return type

any

pageMeta

Public Function pageMeta
source: D:\WebSites\socalcustomwheels.com\cfc\global.cfc

arguments

label	name	required	type	default	hint
	columnName	true	string	null
	columnValue	true	numeric	null

return type

any

ICONAPIKEY

string

RVLYAYDFJZBWOHQOLSFKYWMHTBTMUEQUJOVAOMQPQRRHOBARSK

INTMAXROWS

number

36

ISVEHICLESELECTED

Public Function isVehicleSelected
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label

name

required

type

default

hint

return type

any

ISVEHICLESELECTED_FITMENTGROUP

Public Function isVehicleSelected_FitmentGroup
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label

name

required

type

default

hint

return type

any

MAILER

string

BcPULMksJBqUrwzwsWFiwZLvG99Wz57rXB2TFKBwk2PpWD0ZDSbX02rgRMk4sCvHq3ERnOpokaFHrO4Znnf74uQmal0VX+22NMn/cP6w/3M=

MAKERANDOMSTRING

Public Function makeRandomString
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label

name

required

type

default

hint

return type

string

PACKAGESID

number

8285

PASSWORD

string

Icon!6669

PRETTYURL

Public Function PrettyURL
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	URL	true	string	null
	type	true	string	null
	ID	true	string	null

return type

any

SESSIONS

number

4867

SETTINGS

Query
Template: /models/settings.cfc:4
Execution Time: 3.65 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
SELECT TOP 1 w.intWebsiteID
,w.vchrPrimaryDomain
,w.intAccountID
,w.intConfigID
,w.vchrPrimaryLogo
,w.vchrSecondaryLogo
,w.vchrFavicon
,w.vchrRFQemail
,w.vchrPhysicalAddress
,w.vchrCity
,w.vchrState
,w.vchrPostalCode
,w.vchrCountry
,w.vchrPhoneNumber
,w.vchrHours
,w.vchrFacebookAppID
,w.vchrGoogleAnalyticsProp
,w.vchrMarketingTitle
,w.vchrMarketingKeywords
,w.vchrMarketingDescription
,w.vchrFacebookLink
,w.vchrTwitterLink
,w.vchrYoutubeLink
,w.vchrInstagramLink
,w.vchrTikTokLink
,w.vchrYelpLink
,w.vchrGoogleMapsLink
,w.vchrYoutubePlaylist
,w.blnActive
,w.[vchrRecaptchaSiteKey]
,w.[vchrRecaptchaSecretKey]
,(select TOP 1
c.blnUseSZAppGiude
FROM tbl_configurators c
WHERE c.intConfigID = w.intConfigID
) AS blnUseAppGuide
FROM tbl_website w
WHERE intWebsiteID = 80

intWebsiteID

vchrPrimaryDomain

intAccountID

intConfigID

vchrPrimaryLogo

vchrSecondaryLogo

vchrFavicon

vchrRFQemail

vchrPhysicalAddress

vchrCity

vchrState

vchrPostalCode

vchrCountry

vchrPhoneNumber

vchrHours

vchrFacebookAppID

vchrGoogleAnalyticsProp

vchrMarketingTitle

vchrMarketingKeywords

vchrMarketingDescription

vchrFacebookLink

vchrTwitterLink

vchrYoutubeLink

vchrInstagramLink

vchrTikTokLink

vchrYelpLink

vchrGoogleMapsLink

vchrYoutubePlaylist

blnActive

vchrRecaptchaSiteKey

vchrRecaptchaSecretKey

blnUseAppGuide

1

80

socalcustomwheels.com

467

11623

SO-CAL-CUSTOM-WHEELS-logo--_8529.png

so-cal-logo-white-footer-_4803.png

sales@socalcustomwheels.com

2177 Harbor Blvd

Costa Mesa

CA

92627

USA

1-877-253-8245

Mon-Fri: 9am-6pm PST Sat-Sun: Closed

tire service, tire installation, tires, wheels, performance parts, exterior accessories, suspension parts, interior accessories, cars, trucks, suv's, luxury, sedans, repairs, costa mesa, orange county, signature performance

SoCal Custom Wheels is Orange County's service and installation experts. We can service cars, trucks, SUV's, Jeeps, and luxury sports/sedans and offer wholesale prices to the public on tires, custom wheels, performance upgrades (exhaust, intakes, programmers), suspension (lift kits, lowering kits, shocks/struts, air bags), and accessories (interior/exterior). Repairs include front end repair, brake service, lube, and electrical.

https://www.facebook.com/SoCalCustomWheels/

https://www.youtube.com/channel/UC9gdNr83JhlSGvzHo6zVWnw

https://www.instagram.com/socalcustomwheels/?hl=en

1

6LeZk6kdAAAAAHcWqhCTp_ZJkrgWKgh1MQPG2FKC

6LeZk6kdAAAAACduDfnAV5gmb62VJWwBne3eGorJ

2

SHORTCIRCUITSPAMFORM

Public Function shortCircuitSpamForm
source: D:\WebSites\modules\_functions-V2.cfm

arguments

label	name	required	type	default	hint
	submittedForm	false	any	null

return type

any

SLIDERID

number

143

SNIPCART

string

OTFiNGU5OWMtMWJiMS00NjBjLThlODUtM2Y3ZjViOTQwOTE4NjM4MDA2MjEzNjQ4ODM0MDk2

SYSTEMIMAGEPATH

string

https://images.iconfigurators.app/images/

SYSTEMPATH

string

//www.socalcustomwheels.com/

TESTINGACCOUNTID

number

1856

TITLE

string

SoCal Custom Wheels

TITLESHORT

string

SoCal Custom

UPLOADPATH

string

D:\uploads\

USERNAME

string

icon_cms

VIDEOSID

number

0

VIDEOSLIDESID

number

166

WEBSITECATEGORY

number

7478

WEBSITEID

number

80

WHEELSID

number

0

An unexpected error occurred.