X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id B2893D1C98E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Jan 2004 13:03:38 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 12229-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 29 Jan 2004 09:03:16 -0400 (AST)
Received: from mx.primus-india.net (unknown [203.196.128.60])
	by svr1.postgresql.org (Postfix) with ESMTP id BABC0D1CAD9
	for <pgsql-sql@postgresql.org>; Thu, 29 Jan 2004 09:03:05 -0400 (AST)
Received: from mukta (cfsl-73-129-del.cofuture.com [203.196.129.73] (may be
	forged))
	by mx.primus-india.net (8.12.8/8.12.8) with SMTP id i0TDON8Y009145
	for <pgsql-sql@postgresql.org>; Thu, 29 Jan 2004 18:54:23 +0530
Message-ID: <00a801c3e669$004f08c0$ea08a8c0@mukta>
From: "MUKTA" <muktavasudeva@hfcl.com>
To: <pgsql-sql@postgresql.org>
Subject: 
Date: Thu, 29 Jan 2004 18:38:33 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00A5_01C3E697.1912AB90"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40
X-Spam-Level: 
X-Archive-Number: 200401/254
X-Sequence-Number: 16647

This is a multi-part message in MIME format.

------=_NextPart_000_00A5_01C3E697.1912AB90
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi I have an urgent problem
I want to insert values into a table using the C syscalls provided by the l=
ibpq library, but i find that i can not insert into the table when i use va=
riables instead of values...like so:
int a,b,c,d;
using the C function=20
=20
res=3DPQexecute(Conn,"INSERT into table values(a,b,c,d));....

executing above statement with plain integers does fine and inserts them in=
to 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

------=_NextPart_000_00A5_01C3E697.1912AB90
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Hi I have an urgent problem</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I want to insert values into a table using=
 the C=20
syscalls provided by the libpq library, but i find that i can not insert in=
to=20
the table when i use variables instead of values...like so:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>int a,b,c,d;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>using the C function </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>res=3DPQexecute(Conn,"INSERT into table=20
values(a,b,c,d));....</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>executing above statement with plain integers does fine and inserts th=
em=20
into table..</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is there some special way to insert variab=
les=20
rather than plain values? do i have to build functions (in sql) or=20
somehting?help!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Thanx</FONT></DIV></FONT></DIV></BODY></HT=
ML>

------=_NextPart_000_00A5_01C3E697.1912AB90--