From: Viorel Dragomir <bc@vio.ro>
To: MUKTA <muktavasudeva@hfcl.com>
To: pgsql-sql@postgresql.org
Subject: Re:
Date: Thu, 29 Jan 2004 15:11:44 +0200
Message-ID: <031501c3e669$71b30ca0$6500a8c0@wylog.local> (raw)
References: <00a801c3e669$004f08c0$ea08a8c0@mukta>
So, you are an artist. Isn't it? :)
Your query is actually a string.
This is your string: INSERT into table values(a,b,c,d)
You must change your string to actually use values of tha a, b...
You can make this string with sprintf
sprintf(string, "INSERT into table values(%d,%d,%d,%d)", a, b, c, d);
Then you launch:
res=PQexecute(Conn, string);
Why don't you use PHP? Is easier.
Have a nice day
----- Original Message -----
From: MUKTA
To: pgsql-sql@postgresql.org
Sent: Thursday, January 29, 2004 15:08
Subject: [SQL]
Hi I have an urgent problem
I want to insert values into a table using the C syscalls provided by the libpq library, but i find that i can not insert into the table when i use variables instead of values...like so:
int a,b,c,d;
using the C function
res=PQexecute(Conn,"INSERT into table values(a,b,c,d));....
executing above statement with plain integers does fine and inserts them into table..
Is there some special way to insert variables rather than plain values? do i have to build functions (in sql) or somehting?help!
Thanx
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-sql@postgresql.org
Cc: bc@vio.ro, muktavasudeva@hfcl.com
Subject: Re:
In-Reply-To: <031501c3e669$71b30ca0$6500a8c0@wylog.local>
* 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