What wrong with '?' char in sql query
Issue #79
invalid
So, my query contains ? character. And when I try execute, I receive exception. Please tell me, what I do wrong, or give me solution for contains '?' char in query. Thanks.
SELECT * FROM ZLISTENEXERCISE WHERE ZEDITIONNAME = '2015-6' AND Z_ARTICLENAME = 'What kind of king will Charles be?'
com.almworks.sqlite4java.SQLiteException: [-95] sqlite error at com.almworks.sqlite4java.SQLiteStatement.checkColumn(SQLiteStatement.java:1339) at com.almworks.sqlite4java.SQLiteStatement.columnInt(SQLiteStatement.java:965)
Comments (2)
-
-
- changed status to invalid
- Log in to comment
Hi, there's nothing wrong with "?" char. Error -95 means that you have tried to use
columnInt()
call when there's no active row (query didn't return anything). You need to check the result ofstep()
method.See javadocs in http://almworks.com/sqlite4java/javadoc/com/almworks/sqlite4java/SQLiteStatement.html
Hope this helps, Igor