Mr. Puneet Kishor wrote:
> CREATE TABLE uris (
> uri_id INTEGER PRIMARY KEY,
> uri TEXT
> );
>
>
> CREATE TABLE history (
> history_id INTEGER PRIMARY KEY,
> uri_id INTEGER,
> downloaded_on DATETIME DEFAULT CURRENT_TIMESTAMP
> );
>
> I am looking for an efficient way to select the uris, and the
I have a bunch of uris stored in a table
CREATE TABLE uris (
uri_id INTEGER PRIMARY KEY,
uri TEXT
);
uri_id uri
-- --
1 http://foo.com
2 http://bar.c
Can anyone suggest a good source for sample C++ code? I really would
rather not come here and ask for every little thing--I'd learn it better
this way.
Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailma
Thanks. I saw the message too--at least now I know to send as plain text.
Don Ireland
-Original Message-
From: Simon Slavin
To: General Discussion of SQLite Database
Sent: Sat, 14 May 2011 2:35 PM
Subject: Re: [sqlite] Can't send messages to list from pc?
On 14 May 2011, at 5:17pm, Do
Thanks. I saw the message too--at least
Don Ireland
-Original Message-
From: Simon Slavin
To: General Discussion of SQLite Database
Sent: Sat, 14 May 2011 2:35 PM
Subject: Re: [sqlite] Can't send messages to list from pc?
On 14 May 2011, at 5:17pm, Don Ireland wrote:
> We'll see if t
On 14 May 2011, at 5:17pm, Don Ireland wrote:
> We'll see if this works. I'm sending it from my pc and I sent it as
> plain text.
I can see that message. So there's a chance that your rich text messages are
being sent as attachments and/or without a plaintext equivalent, so the system
rejec
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/13/2011 09:13 PM, Igor Tandetnik wrote:
> prad wrote:
>> i've seen .db and .sqlite and both work.
>> however, is there a rational for one or the other (eg firefox sqlite
>> plugin looks for .sqlite)?
>
> SQLite itself doesn't care. Each applica
> Upgrading zlib to the latest release (1.2.5) fixed all of my valgrind
> warnings
Thanks. I'll try to replicate ...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> Please try the latest code checkin (
> http://www.sqlite.org/src/info/e569f18b98) and let me know if it works any
> better for you.
Thanks. I've already adjusted the code to manually assign keys, but I'll try to
get back to checking it.
___
sqlite-use
> If on thread #1 using connection #1 does a step on a prepared select
> statement and then is blocked before the sqlite3_column() statements and
> tailing reset statement and thread #2 using connection #2 tries to do a step
> of a different select prepared statement on the same DB, will the sec
We'll see if this works. I'm sending it from my pc and I sent it as
plain text.
On 5/13/2011 5:40 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 05/13/2011 02:35 PM, Don Ireland wrote:
>> Anybody have any ideas? This is really odd.
> Two possibilities:
>
> - -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/13/2011 09:33 PM, Don Ireland wrote:
> 1) if I were sending from an address other than the subscribed one, I'd get
> those bounce messages telling me that. But I get NO message at all.
> I'll check the message headers over the weekend though.
Thanks for the responses. The three table approach you describe is what
I normally use, but the export is coming from a filemaker database where
they are stored this way so I thought I'd play with it as is. I was
surprised when I tried a similar query with the same data in MySQL and
saw that i
I have a database where a field's value is a comma separated list
indicating the basic categories the item belongs to.
so if the "categories" field has a value of "1,8,15"
I want to do a query like this:
SELECT categories FROM myTable WHERE "8" IN (categories);
but it only finds records where
14 matches
Mail list logo