Re:

The short answer is no- I can't recall anyone ever having a problem with a
non-integer field if the variable receiving the value is appropriately
typed.

The long answer is that if you can supply a sample of the code where this
problem is occurring, someone on the list may be able to help. In addition,
knowing the versions of various software components (and what they are) is
important. I gather you're using a tag library with JSPs?

-Nick

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Brendan Caylor:
> Forgecom
> Sent: Wednesday, September 03, 2003 5:55 AM
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC]
>
>
> To whom ever it may concern,
>
> We are having trouble with what we think is the JDBC driver.
>
> We can query a PostgreSQL database without problems except for
> when a query
> that contains a field with a data type of decimal. When running a script,
> the following runtime error occurs:
>
> Message: General SQL Error
> Tag Context: CFQUERY: Line=1; Column=1
> Detail: Database reported: Bad Integer 1.95
>
> It seems that its trying to interpret the value of the field,
> which in this
> case is 1.95, as an integer and of course it isn't so bombs.
>
> It would be interesting to know if anyone else has reported a similar
> problem and if so what was the resulting fix to the bug.
>
> What is going wrong here, any help would be much appreciated.
>
> With many thanks in advance,
>
> Brendan Caylor
> Forgecom.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>