Hi guys,
I have a column which describes note type, the value of the type may
be 1, 2, 3.....(some int numbers). The problem is that the type value
may be one of those numbers, or some of the numbers, such as the type
may belong to1 and also belong to 2..
When I create the table, I may create it like this:
"CREATE TABLE " + NOTES_TABLE_NAME + " ("
+ Notes._ID + " INTEGER PRIMARY KEY,"
+ Notes.TYPE + " TEXT"
+ ");");
I set "TEXT" to Notes.TYPE, so it can save the type '1 and 2' like
this "1,2", But when I query the item whose Notes.TYPE is "1", you
know, type "1,2" also satisfys this, And I should do some string
spliting in order to query this.
Is there any easy way to solve this?
Thanks!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
