From: | Simon Drabble <simond(at)foxlink(dot)net> |
---|---|
To: | Anna Langer <anna_langer(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Problems with INSERT INTO? |
Date: | 1999-05-24 13:25:51 |
Message-ID: | Pine.LNX.3.96.990524092454.17623A-100000@dragon |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
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(at)foxlink(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Drabble | 1999-05-24 13:37:08 | Re: [GENERAL] Problems with INSERT INTO? |
Previous Message | Lincoln Spiteri | 1999-05-24 13:16:39 | Re: [GENERAL] Full Text Searches |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Drabble | 1999-05-24 13:37:08 | Re: [GENERAL] Problems with INSERT INTO? |
Previous Message | Herouth Maoz | 1999-05-24 09:46:18 | Re: [GENERAL] Problems with INSERT INTO? |