I'm fairly certain that it's because when you're saying ring_time >
'10', it's asking sqlite to take all strings that are greater than the
string '10'. So all the numbers you presented are greater than 1. What
you want is "where ring_time > 10". Notice the lack of quotes which
means treat 10 as a number instead of a string.
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.
Why?
This row is varchar. Is 3.2.8 not able to work with numbers stored as varchar?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
