Lucee 5.3.3.62 Error (database)
Message The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
SQL select postcodes from countiesandprefixes where county='Darlington' order by postcodes
DatabaseName Microsoft SQL Server
DatabaseVersion 14.00.2027
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100
Datasource DB1
Stacktrace The Error Occurred in
C:\_DOMAINS\fueltool.uk\countysearch.cfm: line 10
8: <cfquery datasource="db1" name="getSubs">
9: select postcodes from countiesandprefixes where county='#url.county#' order by postcodes
10: </cfquery>
11:
12:

Java Stacktrace lucee.runtime.exp.DatabaseException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
  at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
  at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:286)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:261)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:215)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:1055)
  at lucee.runtime.tag.Query._doEndTag(Query.java:655)
  at lucee.runtime.tag.Query.doEndTag(Query.java:537)
  at countysearch_cfm$cf.call(/countysearch.cfm:10)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:911)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
  at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:64)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2409)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2399)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2374)
  at lucee.runtime.engine.Request.exe(Request.java:43)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1055)
  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:741)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:394)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  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)
 
Timestamp 3/28/24 12:13:37 PM GMT