pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ângelo Marcos Rigo <angelo_rigo@yahoo.com.br>
To: col@mportal.hu
Cc: pgsql-php@postgresql.org
Subject: Re: Update script
Date: Fri, 15 Aug 2003 07:53:52 -0300 (ART)
Message-ID: <20030815105352.63670.qmail@web14802.mail.yahoo.com> (raw)
In-Reply-To: <bhh5fj$1jua$1@news.hub.org>

Hi Col 

Thank´s for the postgre version note 
my problem was that i just forget the name=id atribute
in the textfield 

Best regards


 --- CoL <col@mportal.hu> escreveu: > Hi,
> 
> 
> Ângelo Marcos Rigo wrote, On 8/14/2003 3:46 PM:
> > 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 :
> > 
> > <?php
> > 	$id = $_POST['id'];
> > 	$titulo = $_POST['titulo'];
> > 	$texto = $_POST['texto'];
> > 
> > 	include 'db.php'; 
> > 	$query = "UPDATE table SET titulo='$titulo',
> > texto='$texto' WHERE id='$id'";
> print $query; You will get:
> UPDATE table SET titulo='somthing',texto='text'
> WHERE id=''
> 
> And your pg version is >= 7.2, where you can not
> insert '' string in 
> integer type. cast $id as integer, '".($id+0)."' or
> intval or others.
> 
> C.
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster 

=====
Â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



view thread (6+ messages)

Message-ID: <20030815105352.63670.qmail@web14802.mail.yahoo.com>
Permalink:  ../20030815105352.63670.qmail@web14802.mail.yahoo.com/
Also on:    postgresql.org/message-id/20030815105352.63670.qmail@web14802.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: angelo_rigo@yahoo.com.br, col@mportal.hu
  Subject: Re: Update script
  In-Reply-To: <20030815105352.63670.qmail@web14802.mail.yahoo.com>
  References: <bhh5fj$1jua$1@news.hub.org> <20030815105352.63670.qmail@web14802.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox