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)
|
|