Re: [sqlite] SQLite Web Site

On 6-Feb-2008, at 8:41 PM, Dan wrote: > is not valid HTML. It is valid XHTML of course. All browsers > just ignore the "/" character, but I can't think of any document > where this is defined. Does anybody know? W3C's validator said this: The sequence can be interpreted in at least two differen

Re: [sqlite] Version 3.2.2

Literals in SQL use single quotes. Walt wrote: > I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. > > executing the following sql > > UPDATE listings SET buyer = "Price" WHERE listnum = 12345 > > results in the 'buyer' field being set to the contents of the 'price' fiel

Re: [sqlite] SQLite Web Site

On Feb 7, 2008, at 6:12 AM, Scott Baker wrote: > Steven Fisher wrote: >> On 06-Feb-2008, at 12:33 PM, [EMAIL PROTECTED] wrote: >> >>> What do you mean "no longer found"? Do you mean that that >>> you cannot see anything at all, or that the new design is such >>> that it is not displayed correctl

Re: [sqlite] Bug found in the new register-based VM

Maybe it'll be better that hot-fixes goes under the same version plus hot-fix number? For example at 3.5.5 was introduced new VM, so all fixes for this will goes in releases like 3.5.5.X? On Feb 7, 2008 12:57 AM, <[EMAIL PROTECTED]> wrote: > I had been saying in release announcements that no bug

Re: [sqlite] Version 3.2.2

UPDATE listings SET buyer = 'Price' WHERE listnum = 12345 Double quotes are for column names. Walt wrote: > I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. > > executing the following sql > > UPDATE listings SET buyer = "Price" WHERE listnum = 12345 > > results in the '

[sqlite] Version 3.2.2

I have a table 'listings' with fields 'listnum', 'price' and 'buyer' etc. executing the following sql UPDATE listings SET buyer = "Price" WHERE listnum = 12345 results in the 'buyer' field being set to the contents of the 'price' field instead of setting the field 'buyer' to "Price". Need HELP

[sqlite] Bug found in the new register-based VM

I had been saying in release announcements that no bugs have been found in the new register-based virtual machine introduced in SQLite version 3.5.5. That changed with ticket #2927. We have now observed our first register-VM bug. http://www.sqlite.org/cvstrac/tktview?tn=2927 There will likel

Re: [sqlite] SQLite Web Site

Steven Fisher wrote: > On 06-Feb-2008, at 12:33 PM, [EMAIL PROTECTED] wrote: > >> What do you mean "no longer found"? Do you mean that that >> you cannot see anything at all, or that the new design is such >> that it is not displayed correctly? > > Well, the page definitely doesn't validate: > h

Re: [sqlite] SQLite Web Site

On Wed, Feb 06, 2008 at 02:46:31PM -0800, L. S. wrote: > O-o-o-okay! That explains it. > I do vaguely remember that issue being discussed, some time ago. > Well... I'm in Cali', and I'm out of luck on this Palm/Blazer. I can load the SQLite web page in Opera Mini on my phone... ___

Re: [sqlite] SQLite Web Site

O-o-o-okay! That explains it. I do vaguely remember that issue being discussed, some time ago. Well... I'm in Cali', and I'm out of luck on this Palm/Blazer. On 2/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "L. S." <[EMAIL PROTECTED]> wrote: > > The page never loads. I get the message, "T

Re: [sqlite] SQLite Web Site

"L. S." <[EMAIL PROTECTED]> wrote: > The page never loads. I get the message, "The page download could not > be completed. Please try again later." > > Here is the User-Agent header string: > Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; PalmSource/Palm-D052; > Blazer/4.5) 16;320x320 > The webs

[sqlite] error building amalgamation from 3.5.6 source tree

I have a few patches that I apply to SQLite and need to rebuild the amalgamation, but I get an error saying it can't find tsrc/fts3.h I verified on an un-patched 3.5.6 release that the same error occurs, both on Linux and MacOSX 10.5.1. Am I missing a step somewhere? If I remove all the fts3 ref

Re: [sqlite] SQLite Web Site

On 06-Feb-2008, at 12:33 PM, [EMAIL PROTECTED] wrote: > What do you mean "no longer found"? Do you mean that that > you cannot see anything at all, or that the new design is such > that it is not displayed correctly? Well, the page definitely doesn't validate: http://validator.w3.org/check?uri=h

Re: [sqlite] SQLite Web Site

The page never loads. I get the message, "The page download could not be completed. Please try again later." Here is the User-Agent header string: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; PalmSource/Palm-D052; Blazer/4.5) 16;320x320 On 2/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >

Re: [sqlite] when to analyze?

Thanks for that explanation. In my app tables are dropped and created and inserted with data continuously, so the recommended use won't quite apply, but I understand better now. I noticed sqlite_stat1 doesn't get updated if a table is dropped or renamed with ALTER TABLE, so I take it I will have t

Re: [sqlite] SQLite Web Site

"L. S." <[EMAIL PROTECTED]> wrote: > I've been ignoring this issue for a while; the world won't end over this > but... > There is some issue with the newly-designed SQLite web site that > prevents access from my Palm Treo. It used to be accessible, with the > old design. > -- > Often I surf, email

Re: [sqlite] when to analyze?

"RB Smissaert" <[EMAIL PROTECTED]> wrote: > Suppose we have a table with some 10 million rows and this table was > analysed, so sqlite_stat1 has the stats of this table then is it worth it to > analyze again after adding say 1000 more rows? The indexing is still the > same, so no indexes are droppe

Re: [sqlite] SQLite and signal handlers

Felix Radensky <[EMAIL PROTECTED]> wrote: > Hi, > > What is a recommended way of handling signals in daemon > processes using sqlite database ? Is calling sqlite3_interrupt() > in SIGTERM handler considered good enough ? > sqlite3_interrupt() was originally create for the specific purpose of h

Re: [sqlite] JOIN creating counter-intuitive results

P Kishor <[EMAIL PROTECTED]> wrote: > sqlite> select * from node limit 3; > node_id node_type node_name node_confidence > -- -- - --- > 1 ACT Mike Garrison 0.99932 > 2 ACT Pat Cox0.999193 > 3

[sqlite] SQLite Web Site

I've been ignoring this issue for a while; the world won't end over this but... There is some issue with the newly-designed SQLite web site that prevents access from my Palm Treo. It used to be accessible, with the old design. -- Often I surf, email, research, read, and download things using wirele

[sqlite] JOIN creating counter-intuitive results

Hello, I am having trouble grasping the following issue intuitively -- sqlite> select * from node limit 3; node_id node_type node_name node_confidence -- -- - --- 1 ACT Mike Garrison 0.99932 2 ACT Pat Cox

Re: [sqlite] SQLite version 3.5.6

Hello Richard, I think http://www.sqlite.org/cvstrac/wiki?p=ToDo is due for an update. Kind regards Lodewijk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 06, 2008 6:06 PM To: sqlite-users@sqlite.org; [EMAI

[sqlite] when to analyze?

Suppose we have a table with some 10 million rows and this table was analysed, so sqlite_stat1 has the stats of this table then is it worth it to analyze again after adding say 1000 more rows? The indexing is still the same, so no indexes are dropped or created. Also the data of the added rows won'

[sqlite] New SQLite mailing lists.

Two new SQLite mailing lists have been established: sqlite-announce sqlite-dev Additional information and links to pages where you can sign up can be found at http://www.sqlite.org/support.html -- D. Richard Hipp <[EMAIL PROTECTED]> ___ s

Re: [sqlite] How to select Strict Affinity or No Affinity modes?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Scott Chapman wrote: > I take it that there's no way to work around this currently? You can leave out the type for each column when declaring the table schema and no affinity conversions will happen. Alternatively, if you require that a type be decla

[sqlite] SQLite version 3.5.6

SQLite version 3.5.6 is now available on the website. http://www.sqlite.org/download.html There is very little change from version 3.5.5. The reason for this release is that there was a regression in the virtual table mechanism that prevented virtual tables from being used in LEFT OUTER JOIN

[sqlite] SQLite and signal handlers

Hi, What is a recommended way of handling signals in daemon processes using sqlite database ? Is calling sqlite3_interrupt() in SIGTERM handler considered good enough ? Thanks. Felix. -- View this message in context: http://www.nabble.com/SQLite-and-signal-handlers-tp15306961p15306961.html

Re: [sqlite] How to select Strict Affinity or No Affinity modes?

I take it that there's no way to work around this currently? Scott Scott Chapman wrote: > D. Richard Hipp wrote: > >> On Feb 2, 2008, at 7:57 PM, Scott Chapman wrote: >> >> >> >>> I've looked high and low and can't find a way to invoke the other 2 >>> affinity modes. Are they availabl

Re: [sqlite] p in sclp in parse.y

Hello Himanshu, I'll look into it today, and get back. Thanks Uma HG <[EMAIL PROTECTED]> wrote: Hello, Could you tell me what the 'p' in 'sclp' in 'parse.y' stands for? I am trying to make a modification to the grammar file. Also the rule for sclp uses selcollist and the rule for

[sqlite] p in sclp in parse.y

Hello, Could you tell me what the 'p' in 'sclp' in 'parse.y' stands for? I am trying to make a modification to the grammar file. Also the rule for sclp uses selcollist and the rule for selcollist uses sclp in some kind of mutual recursion. Is this a lemon feature or normal with LALR g