Re: [sqlite] Multi-valued attributes

2008-02-13 Thread Samuel Neff
It's called a many-to-many relationship and you use a cross-reference table to represent the relationship. Say you have table Searches - SearchID FromDate ToDate etc... Users UserID FirstName LastName Then to define what users are associated with what searches, you

Re: [sqlite] Multi-valued attributes

2008-02-13 Thread P Kishor
Replying to my question, to add a bit of information specific to my current situation. Please see below -- On 2/13/08, P Kishor <[EMAIL PROTECTED]> wrote: > On 2/13/08, gongchengshi <[EMAIL PROTECTED]> wrote: > > > > I have a table were each row needs to be able to store a list of entries > >

Re: [sqlite] Multi-valued attributes

2008-02-13 Thread P Kishor
On 2/13/08, gongchengshi <[EMAIL PROTECTED]> wrote: > > I have a table were each row needs to be able to store a list of entries from > another table as one of its attributes. For instance the table is a > collection of search filters. The filters table has attributes: FromDate, > ToDate, Users,

Re: [sqlite] Multi-valued attributes

2008-02-13 Thread Darren Duncan
At 5:00 PM -0800 2/13/08, gongchengshi wrote: >I have a table were each row needs to be able to store a list of entries from >another table as one of its attributes. For instance the table is a >collection of search filters. The filters table has attributes: FromDate, >ToDate, Users, Devices.

[sqlite] Multi-valued attributes

2008-02-13 Thread gongchengshi
I have a table were each row needs to be able to store a list of entries from another table as one of its attributes. For instance the table is a collection of search filters. The filters table has attributes: FromDate, ToDate, Users, Devices. The Users attribute is not a single value but a