Received: from ryloth.acucore.com (unknown [65.204.194.43]) by postgresql.org (Postfix) with SMTP id 553F1475990 for ; Wed, 17 Apr 2002 17:43:50 -0400 (EDT) Received: (qmail 31432 invoked from network); 17 Apr 2002 21:52:35 -0000 Received: from localhost (127.0.0.1) by 0 with SMTP; 17 Apr 2002 21:52:35 -0000 Received: from 207.135.57.77 ( [207.135.57.77]) as user dwilson@acucore.com@localhost by webmail.acucore.com with HTTP; Wed, 17 Apr 2002 15:52:34 -0600 Message-ID: <1019080354.3cbdeea2e006c@webmail.acucore.com> Date: Wed, 17 Apr 2002 15:52:34 -0600 From: Dan Wilson To: "Hillensbeck, Preston" Cc: 'Cornelia Boenigk' , pgsql-php@postgresql.org Subject: Re: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 4.0-cvs X-Archive-Number: 200204/54 X-Sequence-Number: 1078 Have you tried echoing the $sql after it is created? it's possible that you have nothing in your php variables. In that case, and empty string would cause and error. Otherwise, postgres doesn't care if you have quotes around an numeric type on insert. -Dan Quoting "Hillensbeck, Preston" : > Hmmm well it still tells me the same thing when I take the quotes off. Is > there some type of casting that I might have to do? I have read about the > cast command, but don't understand how to use it. > > Hi Preston > > @$sql="INSERT INTO checking VALUES('$check_date', '$check_num', > '$check_pay', '$check_amount', '$check_trans_type');"; > > Try your INSERT without '' around '$check_amount'. The quotes are only > used for character-types but not for numeric data. > > Regards > Conni > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >