title: Sqlite query returning 0 even if the value is null
body: <p>Following is the query I use to fetch an int value corresponding to a particular field in my sqlite db table.</p>
  
  <pre><code>"SELECT conn_status FROM profiles WHERE devID = '" + id+"'"
  </code></pre>
  
  <p>If there is no value saved for 'conn_status' corresponding to the devID provided, then the existing value in the table would be null. I retrieve the data from java as shown:</p>
  
  <pre><code>c.getInt(c.getColumnIndex("conn_status"))
  </code></pre>
  
  <p>The problem here is, with the given query , c.getInt returns 0 even if the value existing in the field is null. How can I modify this query such that, it returns a different value instead of 0, say 5, if the value is null.</p>
  
  <p>Any help is appreciated.</p>