sqlite LIKE problem in android
<p>Hello i've spent almost 2 hours trying to figure out why the LIKE statement doesn't work and i only get this error: <code>03-03 11:31:01.770: ERROR/AndroidRuntime(11767): Caused by: android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x89d9f8</code></p>

<p>In SQLiteManager it works perfectly like this: <code>SELECT Word FROM Sign WHERE Word LIKE  'he%';</code>
But when i try to do it from java it won't work.
Here's is my query, i've tried in a lot of ways with no luck:</p>

<pre><code>Cursor cursor = m_db.query(MY_TABLE, new String[] {"rowid","Word"},"Word"+" LIKE '"+" ?"+"%'", new String[]{name}, null, null, null);
</code></pre>

<p>Any ideas? i'm i doing it wrong or is there a bug?</p>

<p>Thanks for your time.</p>
