Sort ListView from SQLite using ORDER BY
<p>I have a ListView populated by a series of data from an SQLite Database.
Now I wanna sort the list based on "project_title" column. As far as I know we need to use ORDER BY</p>

<p>So I put that on the query like this:</p>

<pre><code>ListView listView = (ListView) findViewById(R.id.lstText);
        listView.setOnItemClickListener(this);
        listView.setAdapter(new MySimpleCursorAdapter(this, R.layout.listitems,
                managedQuery(Uri.withAppendedPath(Provider.CONTENT_URI,
                        Database.Project.NAME), new String[] { BaseColumns._ID,
                        Database.Project.C_PROJECTTITLE,
                        Database.Project.C_SMALLIMAGE, Database.Project.C_PROJECTDESCRIPTION, Database.Project.C_BIGIMAGE}, "SELECT " + "project_title" 
                       +" FROM "+"Project"+" ORDER BY "+"project_title"+" COLLATE NOCASE ASC", null, null),
                new String[] { Database.Project.C_PROJECTTITLE,
                        Database.Project.C_SMALLIMAGE, Database.Project.C_PROJECTDESCRIPTION}, new int[] {
                        R.id.txt_title, R.id.image, R.id.txt_list_desc}));
</code></pre>

<p>But then nothing was displayed on the ListView. Can anybody give a correction on my ORDER BY query? Thanks</p>
