Thanks for your reply. What about the second question ?
On May 4, 12:58 pm, Romain Guy <[email protected]> wrote: > > Q1: Method appendWhere can only append ONE query condition? why it > > named "append"? > > Read the javadoc > (http://d.android.com/reference/android/database/sqlite/SQLiteQueryBui...)). > > "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 -~----------~----~----~----~------~----~------~--~---
