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
"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
"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
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:
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
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)
6 matches
Mail list logo