"Lloyd Thomas" <[EMAIL PROTECTED]> writes:
> I did try number literal >10 but mad no difference. I will rebuild the
> database row as an integer.
As an interim solution (prior to changing your database schema), you should be
able to use your existing schema with this query:
select ring_time
-Original Message-
From: Lloyd Thomas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 25, 2006 7:49 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Re: number problem with 3.2.8
I did try number literal >10 but mad no difference. I will rebuild the
database row as an inte
I did try number literal >10 but mad no difference. I will rebuild the
database row as an integer.
Lloyd
- Original Message -
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite" <sqlite-users@sqlite.org>
Sent: Thursday, October 26, 2006 12
Lloyd Thomas
wrote:
I am using sqlite 3.2.8 which is included in PHP5.1. I seem to be
having a problem doing queries where with '>' to search a number.
for instance if I do the following
select ring_time fron calls where ring_time > '10';
I get the following results
3
6
3
6
3
6
2
3
3
3
2
etc.
4 matches
Mail list logo
