Yes, I think TB is configured to send HTML. I take it that mucks things up?
I see the messages in sent items. And as far as confirming that I'm sending to
the right address--I even REPLIED to a message that came through the list.
Don Ireland
-Original Message-
From: Danny
To: General
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.
2) both the DROID and pc send out via the same mail server. Isn't it the server
that would be
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 application is free to choose its own
convention.
--
Igor Tandetnik
__
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)?
--
in friendship,
prad
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
On Fri, 13 May 2011 12:06:23 -0400, Jean-Christophe Deschamps
wrote:
> Dear list,
>
> Is there a way to make SQLite accept this kind of constraint:
>
> CREATE TABLE tab (
>id INTEGER NOT NULL,
>data INTEGER,
>CHECK(data = 0 or not exists (select 1 from tab where id = data)));
Off t
Hello Simon,
Yes I am following that sequence. However I do my sqlite3_column(...) calls to
extract data from selects between the step() and reset() calls.
My concern is the time between the step() and reset() calls if another select
step() is attempted from another thread with a separate DB c
TB giving any errors?
Do they show up in the Sent folder?
The Outbox folder?
Are you sending in HTML instead of text?
Have you confirmed "one more time" that you are sending it to the correct
address?
Can't think of any other questions.
--- On Fri, 5/13/11, Don Ireland wrote:
> From
On 14 May 2011, at 12:29am, John Deal wrote:
> I actually never finalize prepared statements until the DB is closed and not
> being used anymore. I reset the prepared statements. For writes (inserts,
> updates, etc.) I use explicit transactions with commits (or rollbacks if
> errors). I reu
On Fri, 13 May 2011 17:14:32 -0700 (PDT)
John Deal wrote:
> Again thanks for the information and I apologize for taking up so much list
> bandwidth. I hope others can benefit.
Watching this thread was useful to me and I'd like to use this reply to *thank*
Pavel and the
other guys for explaini
On May 13, 2011 8:17 PM, "BareFeetWare" wrote:
> There is no function built into SQLite to convert a text string into a set
(eg convert "1,8,15" into (1, 8, 15)), but such a function is not needed in
this case. You need a better design of your database. SQLite is relational
and you need to make yo
On 14/05/2011, at 5:15 AM, Trevor Borgmeier wrote:
> 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
Hello Pavel,
Many thanks on the extensive information. I think I understand what you are
saying. I do have a couple of questions.
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
statem
Hello Simon,
I actually never finalize prepared statements until the DB is closed and not
being used anymore. I reset the prepared statements. For writes (inserts,
updates, etc.) I use explicit transactions with commits (or rollbacks if
errors). I reuse the prepared statements by rebinding p
-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:
- - You have different from addresses configured on the phone and desktop.
There is no way for the mailing list to know they are the same per
On May 14, 2011 12:31 AM, "Don Ireland" wrote:
>
> It compiles fine, but I get a runtime error:
>
> An unhandled exception of type 'System.DllNotFoundException' occured in
System.Data.SQLite.dll
>
> Additional information: Unable to load DLL 'SQLite.Interop.DLL': The
specified module could not b
Anybody have any ideas? This is really odd.
And it's annoying to have to send from my droid--especially when I need to
copy/paste an error msg that's on my pc because I have to email it to myself
and then send that message on to the list.
Don Ireland
-Original Message-
From: Don Irela
Upgrading zlib to the latest release (1.2.5) fixed all of my valgrind
warnings in Fossil, including those that appeared to have been coming from
SQLite WAL.
On Fri, May 13, 2011 at 3:11 PM, Richard Hipp wrote:
>
>
> On Fri, May 13, 2011 at 2:49 PM, Richard Hipp wrote:
>
>>
>>
>> On Fri, May 13,
On Fri, May 13, 2011 at 11:38 AM, Steven Parkes wrote:
> I gather sqlite3_last_insert_rowid doesn't play well with FTS? I don't see
> an exception noted in the docs but neither are there non-manually managed
> examples.
>
Please try the latest code checkin (
http://www.sqlite.org/src/info/e569f18
Hi,
FTS and sqlite3_last_insert_rowid do not work together. This is a known
shortcoming. Basically this also means that you can't use any triggers
involving FTS.
Regards,
Hartwig
Am 13.05.2011 um 17:38 schrieb Steven Parkes:
> I gather sqlite3_last_insert_rowid doesn't play well with FTS? I
> SELECT categories FROM myTable WHERE (","||categories||",") LIKE "%,7,%";
>
> but I'm guessing LIKE isn't as efficient, and the query is more
> awkward. Any advise would be appreciated. Thanks!
This LIKE is the only way to get information from your table. But you
can do it more efficiently by
On May 13, 2011, at 9:15 PM, Trevor Borgmeier wrote:
> so if the "categories" field has a value of "1,8,15"
Yep, it's a text column. Nothing relational about it.
> Any advise would be appreciated.
Normalize your design.
___
sqlite-users mailing lis
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
On Fri, May 13, 2011 at 2:49 PM, Richard Hipp wrote:
>
>
> On Fri, May 13, 2011 at 2:42 PM, Steven Parkes wrote:
>
>> I'm getting conditional branch warnings from valgrind that all percolate
>> up via a WAL path. Anybody know if these are known & benign?
>>
>
> I noticed this myself just yesterda
> I have not yet figured out why valgrind warns on linux-64 but not on
> linux-32 and whether or not this is anything to be concerned about.
Thanks for letting me know. This is x86_64 for me as well, though on OS X.
___
sqlite-users mailing list
sqlite-u
On Fri, May 13, 2011 at 2:42 PM, Steven Parkes wrote:
> I'm getting conditional branch warnings from valgrind that all percolate up
> via a WAL path. Anybody know if these are known & benign?
>
I noticed this myself just yesterday.
On our pre-release checklist, we have a bullet to run a full bra
I'm getting conditional branch warnings from valgrind that all percolate up via
a WAL path. Anybody know if these are known & benign?
This is, admittedly, off a sqlcipher-patched version of 3.7.6.2. I don't think
that should relate but I'll check if they shouldn't be occurring.
_
It compiles fine, but I get a runtime error:
An unhandled exception of type 'System.DllNotFoundException' occured in
System.Data.SQLite.dll
Additional information: Unable to load DLL 'SQLite.Interop.DLL': The
specified module could not be found. (Exception from HRESULT: 0x8007007E)
Don Ire
Dear list,
Is there a way to make SQLite accept this kind of constraint:
CREATE TABLE tab (
id INTEGER NOT NULL,
data INTEGER,
CHECK(data = 0 or not exists (select 1 from tab where id = data)));
This toy exemple doesn't mean much as it is and the actual situation is
a bit more involved
I gather sqlite3_last_insert_rowid doesn't play well with FTS? I don't see an
exception noted in the docs but neither are there non-manually managed examples.
I'd prefer not to manually mange them but ...
___
sqlite-users mailing list
sqlite-users@sqlit
On Fri, May 13, 2011 at 7:51 AM, Shane Harrelson
wrote:
> The bundled readme, as well as the features page, have an update in red,
> describing
> the decision we made to ship the SDS DLL and the Interop DLL separately for
> all platforms:
>
> "Currently all versions provided as System.Data.SQLite.
On Fri, May 13, 2011 at 3:24 AM, Clay Fowler wrote:
> The downloads at
> http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wikiappear
> broken in various ways:
>
> The precompiled binaries fail to work on desktop from Mono on OS X or on
> Microsoft's CLR from Windows (even with the
On 13 May 2011, at 8:24am, Clay Fowler wrote:
> The precompiled binaries fail to work on desktop from Mono on OS X
.NET and Mono on OS X are extremely sensitive to version numbers. So check
you're using a long-issued up-to-date installation of Mono, but not one of the
bleeding-edge versions w
On Fri, May 13, 2011 at 3:24 PM, Clay Fowler wrote:
> The downloads at
> http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wikiappear
> broken in various ways:
>
> The precompiled binaries fail to work on desktop from Mono on OS X or on
> Microsoft's CLR from Windows (even with the
The downloads at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki appear
broken in various ways:
The precompiled binaries fail to work on desktop from Mono on OS X or on
Microsoft's CLR from Windows (even with the included test.exe) because they
attempt to load SQLite.Interop.
34 matches
Mail list logo