Ghost insert

From: Enrique Rodriguez Lazaro <enrique(at)xpress(dot)es>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Ghost insert
Date: 1999-12-23 09:03:12
Message-ID: 3861E550.8ED9448@xpress.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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.

************

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Enrique Rodriguez Lazaro 1999-12-23 10:27:01 Re: [ADMIN] Ghost insert
Previous Message Dave Page 1999-12-23 08:19:32 RE: pgAdmin v6.5.5 released (yes, I did say 6.5.5!!)