Checkout our DVD Gift Finder

TV Shows » Seinfeld   Friends   Simpsons


Hot DVD Deals  rss feed

View More Hot DVD deals

Gift Ideas (Between $10 and $50)  rss feed

View More Gift Ideas


Railo 3.3.4.003 Error (database)
Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')

ORDER BY salesrank
LIMIT 10' at line 4
SQL
SELECT DISTINCT asin, discount, amazonprice, listprice, title, updatedate FROM deals
WHERE productgroup = 8
AND amazonprice <= 1000
AND asin NOT IN ()

ORDER BY salesrank
LIMIT 10
DatabaseName MySQL
DatabaseVersion 4.1.22
DriverName MySQL-AB JDBC Driver
DriverVersion mysql-connector-java-5.0.6 ( $Date: 2007-03-09 22:13:57 +0100 (Fri, 09 Mar 2007) $, $Revision: 6341 $ )
Datasource dealazon
Stacktrace The Error Occurred in
/web/spendfish.com/www/web/category.cfm: line 109
107: WHERE productgroup = <cfqueryparam cfsqltype="cf_sql_integer" value="#id#">
108: AND amazonprice <= 1000
109: AND asin NOT IN (<cfqueryparam cfsqltype="cf_sql_varchar" value="#request.asinList#" list="true">)
110:
111: ORDER BY salesrank

called from/web/spendfish.com/www/web/dvd/index.cfm: line 15
Java Stacktrace You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
   
   ORDER BY salesrank
   LIMIT 10' at line 4
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934):2934
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616):1616
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708):1708
   at com.mysql.jdbc.Connection.execSQL(Connection.java:3255):3255
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293):1293
   at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:867):867
   at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:231):231
   at railo.runtime.tag.Query.executeDatasoure(Query.java:622):622
   at railo.runtime.tag.Query.doEndTag(Query.java:474):474
   at category_cfm$cf.call(/web/spendfish.com/www/web/category.cfm:109):109
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:799):799
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:746):746
   at dvd.index_cfm$cf.call(/web/spendfish.com/www/web/dvd/index.cfm:15):15
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:799):799
   at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:751):751
   at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:35):35
   at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:24):24
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2035):2035
   at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2002):2002
   at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297
   at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:91):91
   at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103):103
   at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:175):175
   at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:240):240
   at com.caucho.server.hmux.HmuxRequest.handleRequest(HmuxRequest.java:424):424
   at com.caucho.server.port.TcpConnection.run(TcpConnection.java:481):481
   at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:685):685
   at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:607):607
   at java.lang.Thread.run(Thread.java:662):662