On Mon, 22 Sep 2014 14:02:57 -0700, Jungle Boogie <jungleboog...@gmail.com> wrote:
> Igor Tandetnik <i...@tandetnik.org> > wrote Mon, 22 Sep 2014 16:34:18 -0400 >> >> Just as I thought. You are storing your values as text - not as numbers - and >> comparing them accordingly, in alphabetical order. > > Sorry, I'm not certain I know the answer to this as I don't generate the data. > Opening the csv file in Excel, I did have to change the transaction_amount > column from "general" to "number". I think your assumptions are correct, > though. I'll see if I can look at the values in the other database. > > I know the data is generated from a different database and a file is created, > portalusemonthly.csv that's sent to a location where I can get it? portalusemonthly.csv probably lists the amounts as .....,"999.63",.... .....,"16695.36",.... and/or the receiving table doesn't define column transaction_amount as a numeric type (REAL, NUMBER, INTEGER and the like). By the way, lacking a currency or decimal type, the best way to represent money amounts is INTEGER, expressed as cents. > Is there anything I can do post export from the other database to change the > values correctly? Have a look at http://sqlite.org/datatype3.html "2.3 Column Affinity Behavior Example" -- Groet, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users