I want to do: SELECT * FROM <TableName> WHERE <attribute(id)> IN <ArrayList type>
but theres an error 04-24 21:18:41.748: ERROR/Error(29495): android.database.sqlite.SQLiteException: no such table: 1: , while compiling: SELECT * FROM Main WHERE id IN [1] basically i want to select those rows with Attribute(id) which are present in an ArrayList... but the format of the ArrayList is not the same as the one reqd for this type of query(i guess) and i think this is the reason, its not workin correctly Also, if i query it with: SELECT * FROM <TableName> WHERE <attribute(id)> IN <Integer> it shows me the correct result... but obv it only selects that particular id's row... note: ArrayList is replaced with Integer... (which is the data-type of my attribute(id)) Thanks in advance :) -- 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
