SQLite select query with Integer Binding in Android

Question

I'm trying to execute the following sqlite statement inside my android app:

String sql = "SELECT ID, lt, lg FROM Location WHERE ABS(lt-?) <= ? AND ABS(lg-?) <= ?";

I have tried using 'rawQuery' in the following sql statement:

String sql = "SELECT ID, lt, lg FROM Location WHERE ABS(lt-" + lt + ") <= " + ltGridLen  + " AND ABS(lg-" + lg + ") <= " + lgGridLen + " LIMIT 1";

which worked. However, I want to know whether there is any other more efficient way to do this.

CL. · Accepted Answer · 2013-11-20 08:08:22Z

2

rawQuery accepts parameters to bind, but only as an array of Strings. Comparing an integer against a string will not work correctly.

With integers, there are no problems with formatting or SQL injection, so you do not need to use parameters for them.

answered Nov 20, 2013 at 8:08

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1