John Delacour wrote:
> I've only been using SQLite for 5 days so I'm very much a beginner.
> I just spent an hour or so working out how to get a list of column
> headers from a table and come up with the script below, which will do
> fine, but I wonder if there's a more elegant way to do it.
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/25/2011 08:56 AM, Richard Hipp wrote:
>> Thanks for the helpful feedback. Please let us know if you find this
>> solution inadequate or if you encounter other problems.
A far better solution to this kind of thing is to do them the other way
rou
Found it. I had opened the databse with SQLITE_OPEN_NOMUTEX.
For some reason it didn't bite me with 3.7.3 but the timing changed just enough
on 3.7.5 to make it break.
I was originally running with SQLITE_THREADSAFE=1 but had experimented with
changing it...and surprise, surprise...it didn't mat
On Tue, Jan 25, 2011 at 3:17 PM, Black, Michael (IS) wrote:
> Ok...good news for 3.7.5 is that once I increased my commit interval I
> started seeing problems with 3.7.3 -- so I think it's me causing the
> problem.
>
> What I'm doing is a begin/commit in a thread while the main thread is doing
>
Ok...good news for 3.7.5 is that once I increased my commit interval I started
seeing problems with 3.7.3 -- so I think it's me causing the problem.
What I'm doing is a begin/commit in a thread while the main thread is doing a
lot of inserts (almost as fast as possible...doing some other math in
Hello John Delacour...nice to see you join the SCLite list.
Folks, John may be a SCLite beginner, but he has quite a reputation on the
MacScript list. I personally am glad to see him here.
R,
John
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun
On Tue, Jan 25, 2011 at 11:31 AM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> The issues I have with this file control are:
>
> - - It is documented as "internal" but my code sees it hence it is now part
> of
> the external interface of SQLite
>
You are right. This has been fixed.
I've only been using SQLite for 5 days so I'm very much a beginner.
I just spent an hour or so working out how to get a list of column
headers from a table and come up with the script below, which will do
fine, but I wonder if there's a more elegant way to do it.
#!/usr/local/bin/perl
use str
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/24/2011 09:27 PM, Dan Kennedy wrote:
> Does the aspw xFileControl method modify the value of the output
> parameter in this case?
No.
> The idea was that existing VFS implementations would return SQLITE_ERROR
> since they do not recognize SQLIT
On 01/25/2011 09:47 PM, Ian Hardingham wrote:
> Hey guys.
>
> I have the following table:
>
> ratingsTable (id INTEGER PRIMARY KEY AUTOINCREMENT, mtId INTEGER, user
> TEXT, rating INTEGER);
>
> mtId links to another table's primary key
>
> I wish to have a query which gives me the mtId which is rep
Great, many thanks guys.
Ian
On 25/01/2011 14:59, Igor Tandetnik wrote:
> Ian Hardingham wrote:
>> ratingsTable (id INTEGER PRIMARY KEY AUTOINCREMENT, mtId INTEGER, user
>> TEXT, rating INTEGER);
>>
>> I wish to have a query which gives me the mtId which is represented most
>> often in the ratin
Ian Hardingham wrote:
> ratingsTable (id INTEGER PRIMARY KEY AUTOINCREMENT, mtId INTEGER, user
> TEXT, rating INTEGER);
>
> I wish to have a query which gives me the mtId which is represented most
> often in the ratingsTable.
select mtId from ratingsTable group by mtId order by count(*) desc lim
I'm no expert, but I'd do it with:
SELECT COUNT(*) AS count FROM ratingsTable GROUP BY mtId ORDER BY count
DESC LIMIT 1;
:-David Burström
On 01/25/2011 03:49 PM, Puneet Kishor wrote:
>
> Ian Hardingham wrote:
>> Hey guys.
>>
>> I have the following table:
>>
>> ratingsTable (id INTEGER PRIMARY
Ian Hardingham wrote:
> Hey guys.
>
> I have the following table:
>
> ratingsTable (id INTEGER PRIMARY KEY AUTOINCREMENT, mtId INTEGER, user
> TEXT, rating INTEGER);
>
> mtId links to another table's primary key
>
> I wish to have a query which gives me the mtId which is represented most
> often
Hey guys.
I have the following table:
ratingsTable (id INTEGER PRIMARY KEY AUTOINCREMENT, mtId INTEGER, user
TEXT, rating INTEGER);
mtId links to another table's primary key
I wish to have a query which gives me the mtId which is represented most
often in the ratingsTable.
Does anyone have a
On 01/25/2011 07:30 PM, Black, Michael (IS) wrote:
> Yes -- MSVC spits out a bunch of constant expression warnings. Most are
> bogus (e.g. while (1)). I looked at them all.
>
> In this case if it's a compile-time option (which it is) wouldn't you
> normally put it in an #if block?
Normally. But
Yes -- MSVC spits out a bunch of constant expression warnings. Most are bogus
(e.g. while (1)). I looked at them all.
In this case if it's a compile-time option (which it is) wouldn't you normally
put it in an #if block?
It confused me when looking at the code as one or the other block will nev
Hello,
how can I query a FTS3 table for all records NOT containing a specific
string? Something like
SELECT * FROM docs WHERE docs MATCH 'NOT sqlite';
gives the error "malformed MATCH expression".
More generally, I want to translate a boolean function (using &&, || and
the unary negation !) to
18 matches
Mail list logo