i think maybe you should read the DDL again.
>There is something wrong with your database designing. >And you need to add a table storing note type. > >2009/5/22 Jason Proctor ><<mailto:[email protected]>[email protected]> > > >you basically have a one (note) to many (note type) relationship. > >model this with two tables -- > >create table notes (id integer primary key); > >create table note_types (note_id integer references notes, type integer); > >to add a type to a note, insert into note_types. to find out whether >a note is of a particular type, or to get all the types for a >particular note, select from note_types. > > > > >>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! >> > >-- > >jason.software.particle > > > -- jason.software.particle --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
