the only fast sol that i can think of is to group the types together n store in another table... like 1,2 as A 1,2,3 as B etc... then refer rge table for usage!
On Fri, May 22, 2009 at 11:14 AM, quill <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
