Re: [sqlite] Wierd between results

2006-03-25 Thread Lloyd Thomas
AIL 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

Re: [sqlite] Wierd between results

2006-03-25 Thread Kurt Welgehausen
"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

Re: [sqlite] Wierd between results

2006-03-25 Thread drh
"Lloyd Thomas" <[EMAIL PROTECTED]> wrote: > I am not sure if I am being crazy, but I seem to be getting a wierd result > when using 'BETWEEN'. > > if use > SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10; > I get 0 results > but if I do > SELECT count(call_id) as num_rows

Re: [sqlite] Wierd between results

2006-03-25 Thread Lloyd Thomas
t; <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, March 25, 2006 4:14 PM Subject: Re: [sqlite] Wierd between results If i do SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 10 and 6; I get 633 results. Is that normal? - Original Message - From:

Re: [sqlite] Wierd between results

2006-03-25 Thread Lloyd Thomas
If i do SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 10 and 6; I get 633 results. Is that normal? - Original Message - From: "Lloyd Thomas" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Saturday, March 25, 2006 3:48 PM Subject: [sqlite] Wie

[sqlite] Wierd between results

2006-03-25 Thread Lloyd Thomas
I am not sure if I am being crazy, but I seem to be getting a wierd result when using 'BETWEEN'. if use SELECT count(call_id) as num_rows WHERE ring_time BETWEEN 6 and 10; I get 0 results but if I do SELECT count(call_id) as num_rows WHERE ring_time = 7; I get 39 results SELECT count(call_id)