At 12:22 +0300 on 24/05/1999, Anna Langer wrote:
> We are not really sure if this question is right for this mailinglist.
> We have some problem with INSERT INTO and we dont know how to solve it.We
> are writing it in a C-program. We are trying to get an integer from a file
> and put it into a database. And we are sure that we get a interger into our
The proper mailing list is the "interfaces" list, where I am redirecting
this post now.
> int a=500;
> PQexec(conn, "INSERT INTO octets VALUES(a)");
> But the program works when we do like this:
> PQexec(conn, "INSERT INTO octets VALUES(500)");
> It feels like we need to convert int a in some way, byt we dont know how. We
> are beginners with Postgresql.
This is less on the PostgreSQL side, and more on the C side. Just putting
"a" in a string doesn't tell C to pass the variable a. It just passes the
character "a", right?
What you have to do is pass the value of a as part of the command string.
So you have to make a string out of a. This is usually done with sprintf,
sprintf( command, "INSERT INTO octets VALUES(%d)", a );
PQexec( conn, command );
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
In response to
pgsql-interfaces by date
|Next:||From: Simon Drabble||Date: 1999-05-24 13:25:51|
|Subject: Re: [GENERAL] Problems with INSERT INTO?|
|Previous:||From: Alf Lewerken||Date: 1999-05-24 08:08:56|
|Subject: Error Compiling unixODBC|
pgsql-general by date
|Next:||From: Brett W. McCoy||Date: 1999-05-24 11:01:36|
|Subject: Re: [GENERAL] Full Text Searches|
|Previous:||From: Piotr Stelmaszyk||Date: 1999-05-24 09:37:33|
|Subject: PL/pgSQL - accessing arrays|