Error while fetching audio files from sdcard
<p>I am trying to fetch audio files from the sdcard. Here's the code I am using:</p>

<pre><code>//the URI where I want the query to be performed
Uri externalAudio = android.provider.MediaStore.Audio.Media.EXTERNAL_CONTENT_URI;

String projection[] = new String[] {"android.provider.MediaStore.Audio.Media.TITLE"};
Cursor curExternalAudio = cr.query(externalAudio, projection, null, null, null);
//code to display result
</code></pre>

<p>The error is in the last line, but it is caused by the projection array. The error displayed in logcat is as below:</p>

<pre><code>E/AndroidRuntime(1994): Caused by: android.database.sqlite.SQLiteException: near ".": syntax error (code 1): , while compiling: SELECT android.provider.MediaStore.Audio.Media.TITLE FROM audio
</code></pre>

<p>Can anybody tell me what's wrong with this code ??</p>
