Re: [sqlite] SQL query problem

2007-01-16 Thread Umesh Persad
Ahhh .. yes they do have commas in them. I'll remove the commas and try it again. Thanks, Umesh Dan Baker wrote: - Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sqlite] SQL query problem Hi, I was wondering if any

Re: [sqlite] SQL query problem

2007-01-16 Thread Dan Baker
- Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sqlite] SQL query problem Hi, I was wondering if anyone can help with a problem I have having with SQL. I have a table 'people' in a Sqlite database with a column 'popu

Re: [sqlite] SQL query problem

2007-01-16 Thread P Kishor
Hi Umesh, What is the table structure of your SQLite table? Is it what you want it to be? I am assuming "population" should be integer, as you can't really have fractional people. Did you check your imported data and see if it looks the same as in Excel? Did all the data import? Probably yes be