Re: [GENERAL] Prepared statements aren't working with parameters with PQexecParams

2008-09-05 Thread David Wilson
On Fri, Sep 5, 2008 at 2:52 AM, Subspace god <[EMAIL PROTECTED]> wrote: > The following does not work in C++, executed as above, in another session > using two subsequent calls to PQexecParams > > PREPARE myquery (text) AS INSERT INTO myTable (word) VALUES ($1); > EXECUTE myquery($1::text); You'r

[GENERAL] Prepared statements aren't working with parameters with PQexecParams

2008-09-04 Thread Subspace god
The following works executed in the query browser: PREPARE myquery (text) AS INSERT INTO myTable (word) VALUES ($1); EXECUTE myquery('blah'); The following works in C++, executed as two statements with PQexecParams using PQEXECPARAM_FORMAT_BINARY PREPARE myquery AS INSERT INTO myTable (word) VAL