Received: from faroenet.fo ([212.55.59.140]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f09ADXB02585 for ; Tue, 9 Jan 2001 05:13:33 -0500 (EST) (envelope-from poulc@cs.auc.dk) Received: (qmail 23814 invoked by uid 7719); 9 Jan 2001 10:24:31 -0000 Received: from unknown (HELO cs.auc.dk) (192.168.1.130) by 192.168.1.1 with SMTP; 9 Jan 2001 10:24:31 -0000 Message-ID: <3A5AE4B8.E80B9F4C@cs.auc.dk> Date: Tue, 09 Jan 2001 10:15:21 +0000 From: "Poul L. Christiansen" X-Mailer: Mozilla 4.71 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: juerg.rietmann@pup.ch CC: pgsql-sql@postgresql.org Subject: Re: how to store this record ?? pg_atoi References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/86 X-Sequence-Number: 747 Could you post the SQL/CF code? What type of field is the field in the database? I've used Cold Fusion and PostgreSQL and it seems to work fine for me. Poul L. Christiansen juerg.rietmann@pup.ch wrote: > Hello there > > Using coldfusion 4.5.1 together with postgreSQL 7.0.3 I try to store a new > record in my table. There is an inputfield type="text" with the value of 6. > I get the following error when I try to add a new record to the database. > > How to change this ??? > > Thanks in advance ... jr > > 6 > > Error Occurred While Processing Request > > |------------------------------------------------------------------------------------------| > | Error Diagnostic Information | > | | > | | > | ODBC Error Code = S1000 (General error) | > | | > | | > | Error while executing the query; ERROR: pg_atoi: error in "6.000000": can't parse | > | ".000000" | > | | > | | > | The error occurred while processing an element with a general identifier of (CFINSERT), | > | occupying document position (14:3) to (19:76). | > | | > | | > | Date/Time: Tue Jan 9 10:36:28 2001 | > | Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) | > | Remote Address: 172.16.30.7 | > | HTTP Referer: http://mondadori.pup.ch/main.cfm | > | Query String: actionstring=add | > |------------------------------------------------------------------------------------------| > > ============================================ > PFISTER + PARTNER, SYSTEM - ENGINEERING AG > Juerg Rietmann > Grundstrasse 22a > 6343 Rotkreuz > Switzerland > > phone: +4141 790 4040 > fax: +4141 790 2545 > mobile: +4179 211 0315 > ============================================