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
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
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
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
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, the results through pysqlite are coming
through as integers. The funn