SQLite and Android. How do I use String Having in my query??

Question

I have a query that pulls everything from a database into a list view.

return mDb.query(DATABASE_TABLE, new String[] {KEY_ROWID, KEY_HEIGHT, KEY_BODY, KEY_HOMEID},null , null, null, null, null,null);

                                |               String Having is the 3rd from
                                                           last null.

I want only the records where the field KEY_HOMEID matches a variable called journalId which should be a numeric string.

I would also like to know how to bring the variable into my DatabaseAdapter... would ((resource) this.getApplication()).getjournalId()) work?? resource is a class that extends application.

Answer 1

Use a WHERE clause; HAVING is only used with GROUP BY.