neooffice form problem with numerics

From: "Reuben Cummings" <reubano(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: neooffice form problem with numerics
Date: 2008-11-22 19:57:44
Message-ID: 68bad9530811221157h287201d0jb43ad5e7539fd0f3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi, I am trying to use a neooffice form to insert numerical values
into a postgres database and get the following error:

ESTERROR: 42804: column "back_load" is of type numeric but expression
is of type character varying at character 35

ESTHINT: You will need to rewrite or cast the expression.

ESTLOCATION: transformAssignedExpr,
/Users/Shared/src/postgresql/postgresql-8.3.1/build-leo/src/../../src/backend/parser/parse_target.c:440

ESTSTATEMENT: INSERT INTO "public"."security" ( "back_load",
"company_id", "expense_ratio", "front_load", "is_benchmark",
"proxy_id", "security_name", "security_type_id", "ticker", "turnover"
) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10 )

I am using PostgreSQL 8.3.1 on Mac OS X 10.5.5 and have tried the
following drivers:
pg74.216.jdbc3
postgresql-8.3-603.jdbc3
postgresql-8.4dev-700.jdbc3

This also happens no matter what kind of form field I use, formatted
or numerical.

Any advice? Thanks!

Reuben Cummings

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2008-11-23 01:21:48 Re: neooffice form problem with numerics
Previous Message David Wall 2008-11-18 00:29:45 Streaming Blobs in PG 8.3