Anzeigen nach
Anzahl pro Seite



<< < > >>

Railo 4.0.4.001 Error (database)
Message Incorrect syntax near ')'.
SQL
SELECT smanKey, smanName, smanImgFileName
FROM tShopManufacturer
WHERE smanKey IN ()
ORDER BY NEWID()
DatabaseName Microsoft SQL Server
DatabaseVersion 10.50.4339
DriverName Microsoft SQL Server JDBC Driver 3.0
DriverVersion 3.0.1301.101
Datasource ixs_shop
Stacktrace The Error Occurred in
C:\web-data\motochic.ch\http\pages\inc\getManufacturerShop.cfm: line 28
26: SELECT smanKey, smanName, smanImgFileName
27: FROM tShopManufacturer
28: WHERE smanKey IN (#ValueList(qShopManufacturerOrdered.smanKey)#)
29: ORDER BY NEWID()
30: </cfquery>

called fromC:\web-data\motochic.ch\http\pages\inc\getManufacturer.cfm: line 5
called fromC:\web-data\motochic.ch\http\index.cfm: line 537
Java Stacktrace Incorrect syntax near ')'.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197):197
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493):1493
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775):775
   at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676):676
   at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575):4575
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400):1400
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179):179
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154):154
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:649):649
   at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:204):204
   at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:222):222
   at railo.runtime.tag.Query.executeDatasoure(Query.java:627):627
   at railo.runtime.tag.Query.doEndTag(Query.java:475):475
   at pages.inc.getmanufacturershop_cfm$cf.call(C:\web-data\motochic.ch\http\pages\inc\getManufacturerShop.cfm:28):28
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:802):802
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:749):749
   at pages.inc.getmanufacturer_cfm$cf.call(C:\web-data\motochic.ch\http\pages\inc\getManufacturer.cfm:5):5
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:802):802
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:749):749
   at index_cfm$cf.call(C:\web-data\motochic.ch\http\index.cfm:537):537
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:802):802
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:754):754
   at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:36):36
   at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2255):2255
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2222):2222
   at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:315):315
   at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:728):728
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305):305
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222):222
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123):123
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171):171
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99):99
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407):407
   at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589):589
   at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310):310
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1
   at java.lang.Thread.run(Unknown Source):-1