X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D87A3D1F5E6 for ; Thu, 14 Aug 2003 20:17:40 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 66200-10 for ; Thu, 14 Aug 2003 17:17:31 -0300 (ADT) Received: from seapdc01.PNTS (ip63.c216.blk1.bel.nwlink.com [209.20.216.63]) by svr1.postgresql.org (Postfix) with ESMTP id E1E9AD1F48B for ; Thu, 14 Aug 2003 17:14:29 -0300 (ADT) Received: from busbydev (BUSBY-DEV [10.0.0.17]) by seapdc01.PNTS with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id PRCQ9YDW; Thu, 14 Aug 2003 13:31:15 -0700 Message-ID: <052b01c3629f$aa27e810$1100000a@busbydev> Reply-To: "David Busby" From: "David Busby" To: =?iso-8859-1?Q?=C2ngelo_Marcos_Rigo?= , References: <20030814134646.77797.qmail@web14805.mail.yahoo.com> Subject: Re: Update script Date: Thu, 14 Aug 2003 13:07:19 -0700 Organization: Pacific Northwest Ticket Service MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=BAYES_30, HTML_20_30, HTML_TAG_BALANCE_TABLE, REFERENCES X-Spam-Level: X-Archive-Number: 200308/59 X-Sequence-Number: 2236 Do: print $query; in your code to look at the query you send, atoi = ASCII to Integer. It is failing to convert a null string into integer, your query is malformed. /B ----- Original Message ----- From: "Ângelo Marcos Rigo" To: Sent: Thursday, August 14, 2003 06:46 Subject: [PHP] Update script Hi I have a script to update some records in a postgresql database. when i do modify what i have to modify it give me the warning: Warning: pg_query() query failed: ERROR: pg_atoi: zero-length string in /var/www/html/adm/modificar_2.php on line 24 ERROR this is line 24: $result = pg_query($db, $query); this is modificar_2.php : - $titulo
- $texto
"); pg_close($db); ?> This is a snip from modificar_1.php "); print (""); print (""); $row++; } while ($row < $numrows); ?> Thanks in advance ===== Ângelo Marcos Rigo AMR Informática (51) 3348 0870 Rua Pe. Alois Kades 400/210 Porto Alegre /RS/Brasil http://amr.freezope.org angelo_rigo@yahoo.com.br _______________________________________________________________________ Conheça o novo Cadê? - Mais rápido, mais fácil e mais preciso. Toda a web, 42 milhões de páginas brasileiras e nova busca por imagens! http://www.cade.com.br ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
ID$myrow[0]
Título
Texto