Yeah I did. sorry about the rushed typing.
DRH managed to sort it out for me. I had imported a ver 2 database to
version 3 and changed a time values to integers, but forgot to change the
column to integer.
Lloydie-T
----- Original Message -----
From: "Kurt Welgehausen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, March 25, 2006 5:39 PM
Subject: Re: [sqlite] Wierd between results
"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:
if use
SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10;
I get 0 results
You DID specify a table in your actual queries, didn't you?
select * from tbl;
t x y
---------- ---------- ----------
1 100 101
2 100 102
3 100 103
4 100 103
5 200 210
6 200 220
7 200 230
8 300 199
select count(t) from tbl where y=103;
count(t)
----------
2
select count(t) from tbl where y between 102 and 210;
count(t)
----------
5
Regards