Skip site navigation (1) Skip section navigation (2)

Re: [NOOB] try tu put a number with pqexecprepare

From: elekis <elekis(at)gmail(dot)com>
To: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [NOOB] try tu put a number with pqexecprepare
Date: 2008-11-28 10:40:54
Message-ID: 78316ea80811280240w7ad5b056pc8b5a4646bd8285@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
hi, and thanks

something, I don't underdstand, a little research on google say to me
that htonl  and...is in

#include <arpa/inet.h>  a network stuff  is that normal that I have to
use that???

I just wanna put number in the db.(sniff)


thanks

a++




On Fri, Nov 28, 2008 at 11:23 AM, Daniel Verite <daniel(at)manitou-mail(dot)org> wrote:
>        elekis wrote:
>
>> I put the code here
>>
>> http://pastebin.com/m1860cc27
>>
>>
>> I symply try to put the number 5 for the second column, and after
>
> that
>>
>> read the line.
>>
>>
>> but the database, I have taht
>> 83886080 in place of 5.
>
> 83886080 happens to be ntohl(5), it's probably not a coincidence :)
>
> Since  you're using binary format for your integer parameters, you must
> convert them from host byte order to network byte order with htonl() and
> conversely use ntohl() for results.
>
> Best regards,
> --
> Daniel
> PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
>



-- 
http://deathboater.blogspot.com/

In response to

Responses

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2008-11-28 10:48:48
Subject: Re: [NOOB] try tu put a number with pqexecprepare
Previous:From: Daniel VeriteDate: 2008-11-28 10:23:45
Subject: Re: [NOOB] try tu put a number with pqexecprepare

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group