title: SQLite select query with Integer Binding in Android
body: <p>I'm trying to execute the following sqlite statement inside my android app:</p>
  
  <blockquote>
    <p>String sql = "SELECT ID, lt, lg FROM Location WHERE ABS(lt-?) &lt;= ? AND
    ABS(lg-?) &lt;= ?";</p>
  </blockquote>
  
  <p>I have tried using 'rawQuery' in the following sql statement:</p>
  
  <pre><code>String sql = "SELECT ID, lt, lg FROM Location WHERE ABS(lt-" + lt + ") &lt;= " + ltGridLen  + " AND ABS(lg-" + lg + ") &lt;= " + lgGridLen + " LIMIT 1";
  </code></pre>
  
  <p>which worked. However, I want to know whether there is any other more efficient way to do this.</p>