android sqLite prob with where clause
<p>I am building a cursor for a select query.   The WHERE section lookup value refers to a variable which is a path so it has several full stops in it.   </p>

<p>The query doesnt like this and errors , the error says a col doesn't exist named with a name which is the lookup value i.e the path with stops in it. If I use the sqlEscape util on the variable it doesnt cause an error but the lookup fails.</p>

<p>Any suggestions please?</p>
