Re: Question on libpq parameters

At 11:45 PM -0500 11/29/08, Tom Lane wrote:
>Owen Hartnett <owen(at)clipboardinc(dot)com> writes:
>> The following libpq code chokes on me with invalid input to an
>> integer parameter (state == PGRES_FATAL_ERR aPtr == "Error: Invalid
>> Input syntax for integer """ . It fails on the call to
>> PQexecPrepared. I suspect I'm not doing the parameters right. Can
>> anyone spot anything wrong?
>
>You can't just point to integers as if they were strings. Didn't
>your compiler complain about that?
>
> regards, tom lane

Yes, it did. I'm confused. My first parameter is a string, but the
following two are integers. I thought the paramType parameter
indicated the type. Do the integers need to be sprintf'd to strings?
There's only one paramValues array and it's type is a const char *
array.

-Owen