Received: from mx03.gis.net (mx03.gis.net [208.218.130.11]) by postgresql.org (Postfix) with ESMTP id E05A2475B1F for ; Wed, 17 Apr 2002 17:32:52 -0400 (EDT) Received: from shell.gis.net ([208.218.129.18]) by mx03.gis.net; Wed, 17 Apr 2002 17:32:51 -0400 Date: Wed, 17 Apr 2002 17:28:41 -0400 (EDT) From: Chadwick Rolfs To: "Hillensbeck, Preston" Cc: "'pgsql-php@postgresql.org'" Subject: Re: In-Reply-To: <040AE3A029B3D51181D000508BC75D0201387762@MERCURY> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/53 X-Sequence-Number: 1077 On Wed, 17 Apr 2002, Hillensbeck, Preston wrote: > > > @$sql="INSERT INTO checking VALUES('$check_date', '$check_num', > '$check_pay', '$check_amount', '$check_trans_type');"; > check_trans_type is type text > > The error that comes up is ... > Warning: PostgreSQL query failed: ERROR: Bad numeric input format > 'check_trans_type' in /etc/httpd/htdocs/checkbook2.php on line 41 > POST_VARS should always be strings. Have you tried this without the php, as in psql. What happens when you replace, in the insert statement, $check_trans_type, with a correct value? Is it supposed to be like withdrawl, deposit...etc? Good luck Chadwick Rolfs - cmr@gis.net Cleveland State University - Student Music Major - The Holden Arboretum Volunteer Computer Programmer - Student Employee --*I finally found powdered water; I just can't figure out what to add to it*--