Re: [sqlite] Problem with LIMIT and transactions? Or is it just me

2003-10-22 Thread ben . carlyle
Howdy, "Jay Macaulay" <[EMAIL PROTECTED]> 23/10/2003 05:55 AM To: <[EMAIL PROTECTED]> cc: Subject:[sqlite] Problem with LIMIT and transactions? Or is it just me > I am running into a real odd problem that I hope someone can explain. I > have a

[sqlite] Re: Problem

2003-10-22 Thread D. Richard Hipp
Reply at the bottom. LucaBala wrote: I've a table (COLOURS) with 8 rows (like below), columns CODE (integer primary key) and NAME: 100 BLACK 103 BLUE 104 GREEN 109 GRAY 111 LIGHT GREEN 112 LIGHT BLUE 120 LIGHT RED 121 RED When I do this command... SELECT * FROM colours WHERE code >= 100

[sqlite] Work around for count (distinct a) ?

2003-10-22 Thread Jonas Forsman / Axier.SE
Hi, I have noticed that it is hard to acheive the count (distinct a) command in sqlite. However, I have tried the suggested work around by: SELECT count(ticker) FROM (SELECT DISTINCT ticker FROM ListDetail WHERE TableName LIKE "sixty%" AND Ticker <> "" This is also giving an error, is there