Re: [GENERAL] Problems with INSERT INTO?

On Mon, 24 May 1999, Anna Langer wrote:

> Hi!
> 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
> program.
>
> When we created the table in the database we set the attribut to int4.
> We get the problem when we trying to move the interger to the database.
>
> 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.
>
> /Anna and Maria
>

Do this:

PQexec(conn, "INSERT INTO octets VALUES(%d)", a);

and read up on C's printf family of functions.


Simon.


--
  On October 7, 1998 the routine process of running anti-virus software on a
  Windows NT server at the Boeing Corporation shut the system down. Evidently,
  the software identified Windows NT itself as a virus and disabled it.
                  -- http://www.vcnet.com/bmc/departments/nt/bugs.shtml

   Simon Drabble                      Somewhere in cyberspace
   simond@foxlink.net