select bf.*, b.bok_file_mask, b.bok_ol_for_epub
from book_format bf
inner join book b on bf.bok_id = b.bok_id
where bok_format_status = 1 and b.bok_id =
and bok_download_format in (1,3,45,46)
order by bok_download_format asc
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 'and bok_download_format in (1,3,45,46)
order by bok_download_format asc' at line 5
ErrorCode
string
0
Extended_Info
string
ExtendedInfo
string
Message
string
NativeErrorCode
number
1064
queryError
string
select bf.*, b.bok_file_mask, b.bok_ol_for_epub
from book_format bf
inner join book b on bf.bok_id = b.bok_id
where bok_format_status = 1 and b.bok_id =
and bok_download_format in (1,3,45,46)
order by bok_download_format asc
Sql
string
select bf.*, b.bok_file_mask, b.bok_ol_for_epub
from book_format bf
inner join book b on bf.bok_id = b.bok_id
where bok_format_status = 1 and b.bok_id =
and bok_download_format in (1,3,45,46)
order by bok_download_format asc
SQLState
string
42000
StackTrace
string
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936):936
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985):2985
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631):1631
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723):1723
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277):3277
at com.mysql.jdbc.Connection.execSQL(Connection.java:3206):3206
at com.mysql.jdbc.Statement.execute(Statement.java:727):727
at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214
at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:224):224
at railo.runtime.tag.Query.executeDatasoure(Query.java:687):687
at railo.runtime.tag.Query.doEndTag(Query.java:531):531
at m.shop.act_build_booklist_cfm$cf.call(/var/www/vhost1/ROOT/m/shop/act_build_booklist.cfm:108):108
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813
at m.shop.index_cfm$cf.call(/var/www/vhost1/ROOT/m/shop/index.cfm:56):56
at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
at railo.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:39):39
at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:19):19
at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212
at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179
at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331
at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717):717
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290):290
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233):233
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191):191
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127):127
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102):102
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109):109
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293):293
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190):190
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291):291
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:776):776
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705):705
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898):898
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690):690
at java.lang.Thread.run(Thread.java:636):636
TagContext
Array
1
Struct
codePrintHTML
string
106: and bok_download_format in (1,3,45,46)<br>
107: order by bok_download_format asc<br>
<b>108: </cfquery></b><br>
109: <cfset get_all_download_formats = evaluate("get_all_download_formats#b#")><br>
110: <br>
codePrintPlain
string
106: and bok_download_format in (1,3,45,46)
107: order by bok_download_format asc
108: </cfquery>
109: <cfset get_all_download_formats = evaluate("get_all_download_formats#b#")>
110: