Re: [sqlite] number problem with 3.2.8

2006-10-25 Thread Vitali Lovich 
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]
-

[sqlite] number problem with 3.2.8

2006-10-25 Thread Lloyd Thomas 
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?