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

[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