net.sqlcipher.database.SQLiteException: variable number must be between ?1 and ?999 about sqlcipher HOT 6 CLOSED

我的问题原因在于 Cursor cursor = db.query(DBConstants.TABLENAME, null, "netid=?"+netid,
null, null, null, null);

不应该将条件直接拼接
换成： Cursor cursor = db.query(DBConstants.TABLENAME, null, "netid=?",
new String[] { netNoteId }, null, null, null);
ok 完美解决！！！

from sqlcipher.

The answer from cuijianzhi actually worked for me haha, first I was trying to query my data using:

Cursor cursor = db.rawQuery("SELECT " + choice + " FROM consumption WHERE day = ?" dayTime ,null);

where dayTime (is a String) was something like "03052016". Like bigmickyg i got the error "variable number must be between ?1 and ?999". Now after creating a new String or whatever new String[] { dayTime } is doing, it finally worked 💃

Cursor cursor = db.rawQuery("SELECT " + choice + " FROM consumption WHERE day = ?",new String[] { dayTime } ,null);

from sqlcipher.

Hello Michael,

The error you are seeing is coming back from the parser, there is no inherent limitation on the primary keys size or inclusion of large numbers in queries. Most likely there is something wrong with the query you are using that is causing the large number to be interpreted as a bind parameter, see below.

https://www.sqlite.org/lang_expr.html#varparam

If you send over the exact code and query you are using we could take a look.

from sqlcipher.

Hello,

Thanks for the prompt reply.

For the moment we've worked around it by including the number directly in the query rather than in the whereArgs parameter.

We will review our query. It's very long and rather complicated - so we'll have a look first.

Regards,

Michael

from sqlcipher.

Michael,

Excellent, sounds good. I'm going to close this ticket for now, but please feel free to re-open or comment again at a later date.

Cheers,
Stephen

from sqlcipher.

Hello cuijianzhi,

I am not sure that I follow what you are saying above, please feel free to ask questions regarding SQLCipher on our mailing list, or you can create a new issue here if you are reporting a problem. Thanks!

from sqlcipher.