Log-in | Logged Out | Create Account
Top
Home Find a Filter Available Brands services Contact Us
whitebar

Find a Filter
Product Catalog

- Industrial Air & Gas Filters
- Fuel Filters & Separators
- HVAC Filters
- Hydraulic Filters
- Liquid Filters
- Microfiltration
- Oil & Lubricant Filters
- Industrial Vehicle Filters
- Water Filters
- Filter Media & Filter Aids

Industries

- Power Generation

Services


- Engineering/Tech Support
- Filter Recycling
- Filter Supply Chain Mgmt.

Available Brands

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]'allTRIM' is not a recognized built-in function name.
 
The error occurred in C:/inetpub/wwwroot/efilters.com/catalog/catdetail.cfm: line 25
Called from C:/inetpub/wwwroot/efilters.com/index.cfm: line 90
Called from C:/inetpub/wwwroot/efilters.com/catalog/catdetail.cfm: line 25
Called from C:/inetpub/wwwroot/efilters.com/index.cfm: line 90
23 : JOIN Mfgr
24 : ON Part.MFGRCODE = Mfgr.MFGRCODE
25 : where '#URL.mktgroup#' in (Filtratk.MKTGROUP, Filtratk.MKTGROUP2, Filtratk.MKTGROUP3, Filtratk.MKTGROUP4) AND part.mfgrcode='FILTK' <cfif isDefined('URL.prodcode')>AND part.prodcode='#URL.prodcode#'</cfif> <cfif isDefined('URL.constyle')>AND part.CONSTYLECD='#URL.constyle#'</cfif> AND WEBPURCHOK = .T. AND WEBPRICE > 0
26 : ORDER by TRIMPARTNO
27 : </cfquery>

SQLSTATE   HY000
DATASOURCE   kingfilt_filterdb
VENDORERRORCODE   195
SQL    SELECT allTRIM(Part.PARTNO) AS TRIMPARTNO, alltrim(Part.MFGRCODE) as mfgrcode, Part.DESC, Part.PRODCODE, Part.CONSTYLECD, Part.WEBPRICE, Part.WEBPURCHOK, Mfgr.MFGRCODE, Mfgr.MFGRNAME, Filtratk.PARTNO, Filtratk.MKTGROUP, Filtratk.MKTGROUP2, Filtratk.MKTGROUP3, Filtratk.MKTGROUP4 from part join filtratk on part.partno = filtratk.partno JOIN Mfgr ON Part.MFGRCODE = Mfgr.MFGRCODE where 'O' in (Filtratk.MKTGROUP, Filtratk.MKTGROUP2, Filtratk.MKTGROUP3, Filtratk.MKTGROUP4) AND part.mfgrcode='FILTK' AND part.prodcode='PA' AND part.CONSTYLECD='D' AND WEBPURCHOK = .T. AND WEBPRICE > 0 ORDER by TRIMPARTNO
Resources:

Browser   claudebot
Remote Address   3.80.129.195
Referrer  
Date/Time   28-Mar-24 08:43 AM
Stack Trace
at cfcatdetail2ecfm1064204281.runPage(C:/inetpub/wwwroot/efilters.com/catalog/catdetail.cfm:25) at cfindex2ecfm975044344.runPage(C:/inetpub/wwwroot/efilters.com/index.cfm:90) at cfcatdetail2ecfm1064204281.runPage(C:/inetpub/wwwroot/efilters.com/catalog/catdetail.cfm:25) at cfindex2ecfm975044344.runPage(C:/inetpub/wwwroot/efilters.com/index.cfm:90)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]'allTRIM' is not a recognized built-in function name.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfcatdetail2ecfm1064204281.runPage(C:\inetpub\wwwroot\efilters.com\catalog\catdetail.cfm:25)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2795)
	at cfindex2ecfm975044344.runPage(C:\inetpub\wwwroot\efilters.com\index.cfm:90)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)