[sqlite] self test for sqlite-amalgamation-3.6.5

Hi, I tried to execute the test for sqlite-amalgamation-3.6.5 repository but there are some test cases which getting hanged like lock-4.3... Expected: [1 {database is locked} {0 1 2 3 4 5}] Got: [1 {database is locked} {}] lock-5.1... Ok lock-5.2..

Re: [sqlite] Multiple Process Notification

Thank you Kees! On 23-Nov-08, at 11:18 AM, Kees Nuyt wrote: > On Sun, 23 Nov 2008 10:33:28 -0600, "Dan Saul" > <[EMAIL PROTECTED]> wrote in General Discussion of > SQLite Database : > >> Hi SQLite, >> >> I would like to monitor an sqlite file for changes over the

[sqlite] asp and sqlite ( not .net )

Hi, I'm looking into using sqlite in combination with asp. I am limited to using the old asp and NO .net, therefore i've been looking arround how i can manage to get asp working with sqlite but all i seem to be able to find are asp.net wrappers. Does anybody has any advice on how to do this?

[sqlite] SQLite - Upade trigger

Hi I'm new to SQLite and triggers. Is it possible to set a trigger so it updates a field of a new record in a table to the same value as the Autoincrement field. i.e. Field1, Integer Autoincrement Field2, Integer Field3, Text Field4, Text When the user enters text in Field3 & Field4, Field1

Re: [sqlite] Multiple Process Notification

On Sun, 23 Nov 2008 10:33:28 -0600, "Dan Saul" <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >Hi SQLite, > >I would like to monitor an sqlite file for changes over the boundary >of a process. The function sqlite3_update_hook appeared promising

[sqlite] feature enhancement request for explain query plan

Having been bitten by my misunderstanding of how sqlite uses indices, I would like to make a request for a feature enhancment. Currently, explain query plan lists the index being used with each table. It would be very convenient if it would also list the columns of that index being used. Thus,

Re: [sqlite] Break compatibility with linux 2.4 in SQLite 3.6.7?

>> When you said breaking compatibility with 2.4, you meant >> NPTL vs LinuxThreads, right? > > My thought as well. There are still some architectures which do not > support NPTL, even with 2.6 kernels (hppa comes to my mind). But lack > of NPTL support causes pain in other areas, too, so it's

Re: [sqlite] Listing top 10 companies through COUNT?

On Sun, 23 Nov 2008 16:40:11 +0800, "Eugene Wee" <[EMAIL PROTECTED]> wrote: >Oops, and as for top 10, a LIMIT 10 clause may suffice, e.g., >SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY >code_count DESC LIMIT 10; > >However, if you wish to show the next 10, then the

Re: [sqlite] Listing top 10 companies through COUNT?

Oops, and as for top 10, a LIMIT 10 clause may suffice, e.g., SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY code_count DESC LIMIT 10; However, if you wish to show the next 10, then the next 10, etc, then you might consider the technique described in this wiki

Re: [sqlite] Listing top 10 companies through COUNT?

Hi, It sounds like you want a GROUP BY clause, e.g., SELECT code, COUNT(code) AS code_count FROM companies GROUP BY code ORDER BY code_count DESC; Regards, Eugene Wee On Sun, Nov 23, 2008 at 4:16 PM, Gilles Ganault <[EMAIL PROTECTED]>wrote: > Hello > >I tried a few things, but I still

[sqlite] Listing top 10 companies through COUNT?

Hello I tried a few things, but I still can't find how to do this: The Companies table contains one row for each company; each row has a Code field that indicates the type of activity this company is into. I'd like to count how many companies belong to each activity, and display the top