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
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
> >
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,
"Sam Carleton" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> I am trying to create a table with two indexes:
>
> CREATE TABLE favorites (
>cust_id CHAR(32) NOT NULL,
>fldoid CHAR(38) NOT NULL,
>imgoid CHAR(64) NOT NULL,
>PRIMARY KEY (cust_id),
>INDEX (fldoid,
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.
I am trying to create a table with two indexes:
CREATE TABLE favorites (
cust_id CHAR(32) NOT NULL,
fldoid CHAR(38) NOT NULL,
imgoid CHAR(64) NOT NULL,
PRIMARY KEY (cust_id),
INDEX (fldoid, imgoid));
SQLite keeps complaining saying there is an error around INDEX. What
might
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Norman Young wrote:
> We had to exclude references to sqlite3_enable_load_extension and
> sqlite3_load_extension from within apsw.c, in order to avoid undefined
> symbol references during the build (python setup.py install).
You should have modified
On Feb 12, 2008 4:04 AM, Roger Binns <[EMAIL PROTECTED]> wrote:
>
> Norman Young wrote:
> > Can this same interface be accessed in Python?
>
> That API has to be wrapped.
>
> > Can this be done from Python via the sqlite3 module? Can you point me to
> > examples?
>
> I have implemented it in APSW
On Feb 13, 2008 1:01 PM, Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote:
> Thank you for a clear and precise answer.
>
> I seem to recall that it is possible to have in-memory databases with
> sqlite. But perhaps that is only possible with alot of tinkering and
> using the C functions. Is that
On Fri, Feb 01, 2008 at 11:46:06AM -0500, Rob Sciuk wrote:
> Actually, upon inspection, that may be an artifact of an earlier attempt
> to run the tests as root, the "chocolate" directory was, in fact owned by
> root. I'm re-running the tests, having removed that directory, and I'll
> repost
On Feb 13, 2008, at 11:12 AM, [EMAIL PROTECTED] wrote:
> Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote:
>> I have a table with two variables, say A and B (both integers). The
>> table is rather large - around 2.9 GB on disk. Every combination of
>> (A,B) occurs only once. I am creating a unique
On Feb 11, 2008 10:51 AM, Lars Aronsson <[EMAIL PROTECTED]> wrote:
> Is there any documentation of how people use SQLite in odd ways in
> their everyday activities?
I used to work with the NS-2 network simulator as an undergrad at NMT
for some experiments we were doing in wireless power control
Kasper Daniel Hansen <[EMAIL PROTECTED]> wrote:
> I have a table with two variables, say A and B (both integers). The
> table is rather large - around 2.9 GB on disk. Every combination of
> (A,B) occurs only once. I am creating a unique index as
>CREATE UNIQUE INDEX ABidx ON abtable (A,B)
I have a table with two variables, say A and B (both integers). The
table is rather large - around 2.9 GB on disk. Every combination of
(A,B) occurs only once. I am creating a unique index as
CREATE UNIQUE INDEX ABidx ON abtable (A,B)
It seems that the (A,B) index is created much slower
Greetings!
I have an application that writes a small SQLite database (well, several
small databases), and an ActiveX control that reads them. One of the
tables has three columns: a foreign key into another table, a value
(which should be a double, but in the file I looked at, they're all
I write GUI automation scripts using the AppleScript language and the
System Events application agent on Mac OS X 10.4 and 10.5. These
scripts are used to QA test Mac software. My scripts need to write
applications states to disk, read/write preferences, read input data,
and compare
"Igor Sereda" <[EMAIL PROTECTED]> wrote:
> The questions around sqlite3_blob_xxx methods that Roger brought up a couple
> of months ago are very interesting for me too, and I haven't seen any reply
> to Roger's message. (Roger - do you have any update?)
>
> As far as I can gather from the cited
The questions around sqlite3_blob_xxx methods that Roger brought up a couple
of months ago are very interesting for me too, and I haven't seen any reply
to Roger's message. (Roger - do you have any update?)
As far as I can gather from the cited description of the problem, we should
manually
On Wed, 13 Feb 2008 13:42:20 +0100, Gilles Ganault
<[EMAIL PROTECTED]> wrote:
(snip)
Oops, wrong forum at Gmane :-) Sorry for the wrong posting.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello
When a call comes in, I'd like to fork a Python script that
broadcasts a message so that users see the CID name + number pop up on
their computer screen, and simultaneously ring their phones.
The following script doesn't work as planned: It waits until the
script ends before moving
21 matches
Mail list logo