From: Enrique Rodriguez Lazaro <enrique@xpress.es>
To: pgsql-interfaces@postgreSQL.org
Subject: Ghost insert
Date: Thu, 23 Dec 1999 10:03:12 +0100
Message-ID: <3861E550.8ED9448@xpress.es> (raw)
Hi.
I am trying to do a interface from a web over my database postgresql
whit libpq.
I can't do a simple 'insert' from libpq.
I'm doing this:
sprintf(temp_string,"insert into clientes
values('fff','prueba','123','123','pepe gotera','jjjjjj','jjj')");
res1=PQexec(conn,temp_string);
tuplas=PQresultStatus(res1);
imprime_cab_html(0);
printf("Resultado: %s<br><p>\n",PQresStatus(tuplas));
printf("Temp_string: %s\n",temp_string);
*****
And the result on my web it's OK:
Resultado: PGRES_COMMAND_OK
Temp_string: insert into clientes
values('fff','prueba','123','123','pepe gotera','jjjjjj','jjj')
But the insert hasn't effect on my database. If from my database i do
'select * from clientes;' the result it's empty.
Where it's the problem?.
Thanks in advanced.
************
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: enrique@xpress.es
Subject: Re: Ghost insert
In-Reply-To: <3861E550.8ED9448@xpress.es>
* 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