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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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