[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

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