X-Original-To: pgsql-php@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DAF4F4758F1 for ; Sat, 22 Feb 2003 11:07:48 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 73693-01 for ; Sat, 22 Feb 2003 11:07:38 -0500 (EST) Received: from web10410.mail.yahoo.com (web10410.mail.yahoo.com [216.136.128.123]) by postgresql.org (Postfix) with SMTP id 029E647590C for ; Sat, 22 Feb 2003 11:07:22 -0500 (EST) Message-ID: <20030222160726.91848.qmail@web10410.mail.yahoo.com> Received: from [198.64.14.164] by web10410.mail.yahoo.com via HTTP; Sat, 22 Feb 2003 08:07:26 PST Date: Sat, 22 Feb 2003 08:07:26 -0800 (PST) From: Bruce Young Subject: updating integer column To: PostgresPHP MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/44 X-Sequence-Number: 1895 hi all, i have a table with an int8 column. my PHP script should update a row with the new values in the form. it works fine if i put a number in the field but gives this error if left blank: Warning: pg_exec() query failed: ERROR: Bad int8 external representation "" in /home/httpd/htdocs/forms/manage/update_profile.php on line 140 how can i get around this.. oh and what is the best datatype to use for a 10 digit phone number?. any help appreciated. thanks - bruce __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/