Re: PySqlite - division of real numbers without decimal fractions

2008-11-10 Thread Astley Le Jasper
On 8 Nov, 05:39, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: > On Fri, 07 Nov 2008 14:36:52 +0100, Gerhard Häring <[EMAIL PROTECTED]> > declaimed the following in comp.lang.python: > > > Astley Le Jasper wrote: > > > I've been getting errors recently when using pysqlite. I've declared > > > the ta

Re: PySqlite - division of real numbers without decimal fractions

2008-11-07 Thread Gerhard Häring
Astley Le Jasper wrote: I've been getting errors recently when using pysqlite. I've declared the table columns as real numbers to 2 decimal places (I'm dealing with money), MySQL doesn't have any MONEY type. All it has is INTEGER, REAL, TEXT, BLOB and NULL types. but when doing division on

Re: PySqlite - division of real numbers without decimal fractions

2008-11-07 Thread Astley Le Jasper
On Nov 7, 6:36 am, Dan Bishop <[EMAIL PROTECTED]> wrote: > On Nov 6, 3:46 pm, Astley Le Jasper <[EMAIL PROTECTED]> wrote: > > > I've been getting errors recently when using pysqlite. I've declared > > the table columns as real numbers to 2 decimal places (I'm dealing > > with money), but when doing

Re: PySqlite - division of real numbers without decimal fractions

2008-11-06 Thread Dan Bishop
On Nov 6, 3:46 pm, Astley Le Jasper <[EMAIL PROTECTED]> wrote: > I've been getting errors recently when using pysqlite. I've declared > the table columns as real numbers to 2 decimal places (I'm dealing > with money), but when doing division on two numbers that happen to > have no decimal fractions