> Q1: Method appendWhere can only append ONE query condition? why it > named "append"?
Read the javadoc (http://d.android.com/reference/android/database/sqlite/SQLiteQueryBuilder.html#appendWhere(java.lang.CharSequence)). "Append a chunk to the WHERE clause of the query. All chunks appended are surrounded by parenthesis and ANDed with the selection passed to query(SQLiteDatabase, String[], String, String[], String, String, String). The final WHERE clause looks like: WHERE (<append chunk 1><append chunk2>) AND (<query() selection parameter>)" So the behavior you are seeing is exactly what's described. If you want to AND several conditions using appendWhere, you must put the AND in each chunk. -- Romain Guy Android framework engineer [email protected] Note: please don't send private questions to me, as I don't have time to provide private support. All such questions should be posted on public forums, where I and others can see and answer them --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
