Received: from localhost (p5080146A.dip.t-dialin.net [80.128.20.106]) by postgresql.org (Postfix) with ESMTP id 701BB475966 for ; Wed, 17 Apr 2002 17:46:23 -0400 (EDT) Received: from eckhard by localhost with local (Exim 3.35 #1 (Debian)) id 16xxFw-0001gJ-00 for ; Wed, 17 Apr 2002 23:46:24 +0200 Date: Wed, 17 Apr 2002 23:46:24 +0200 From: Eckhard Hoeffner To: pgsql-php@postgresql.org Subject: Re: Message-ID: <20020417214624.GA6452@fifoost.org> Mail-Followup-To: pgsql-php@postgresql.org References: <040AE3A029B3D51181D000508BC75D0201387763@MERCURY> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-15 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: <040AE3A029B3D51181D000508BC75D0201387763@MERCURY> User-Agent: Mutt/1.3.28i X-Archive-Number: 200204/56 X-Sequence-Number: 1080 * Hillensbeck, Preston [17 04 02 23:30]: >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. Looks like the definition of the attribut check_trans_type is not text, but numeric. The quotes are not needed when entering numeric data but they also do not disturb.=20 > > >Hi Preston > >@$sql=3D"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. > --=20 --//--\\-- Eckhard Hoeffner e-hoeffner@fifoost.org Tal 44=20 D-80331 M=FCnchen