What wrong with '?' char in sql query

[Evgeny Bozhko]

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)

[Igor Sereda]

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 of step() method.

See javadocs in http://almworks.com/sqlite4java/javadoc/com/almworks/sqlite4java/SQLiteStatement.html

Hope this helps, Igor