| From: | "Laurent Marzullo" <laurent(dot)marzullo(at)atosorigin(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | PQexecParams and CURSOR |
| Date: | 2005-01-14 11:31:24 |
| Message-ID: | NDEKIMJLKBNGEIOBDFOJEECADEAA.laurent.marzullo@atosorigin.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I Could not achieve to use CURSOR with PQexecParams ! How to you do ?
Here what I've done:
1)------------------------------------
paramValues[0] = "2"; // This is the parameter for the query
res = PQexec( conn , "DECLARE MY_CURSOR FOR "
"SELECT * FROM GRGL.RANGE_MODIFIER "
"WHERE WEAPON_ID = $1" );
=> ERROR
DECLARE failed: ERROR: There is no parameter 1
2)------------------------------------
then
paramValues[0] = "2"; // This is the parameter for the query
res = PQexecParams( conn ,
"DECLARE MY_CURSOR FOR "
"SELECT * FROM GRGL.RANGE_MODIFIER "
"WHERE WEAPON_ID = $1",
1,
NULL,
paramValues,
NULL,
NULL,
0);
res = PQexec( conn , "FETCH 1 FROM MY_CURSOR" );
=> Error
FETCH failed: ERROR: no value found for parameter 1
3)--------------------------------------
then
paramValues[0] = "2"; // This is the parameter for the query
res = PQexecParams( conn ,
"DECLARE MY_CURSOR FOR "
"SELECT * FROM GRGL.RANGE_MODIFIER "
"WHERE WEAPON_ID = $1" ,
1,
NULL,
paramValues,
NULL,
NULL,
0); );
res = PQexecParams( conn ,
"FETCH 1 FROM MY_CURSOR",
1,
NULL,
paramValues,
NULL,
NULL,
0);
=> Error:
FETCH failed: ERROR: bind message supplies 1 parameters, but prepared
statement "" requires 0
PLEASE, COULD YOU HELP ? THANKS.
Laurent Marzullo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Neuhauser | 2005-01-14 12:06:25 | pl/pgsql trigger: syntax error at or near "ELSEIF" |
| Previous Message | mike | 2005-01-14 11:28:50 | Invalid input for numeric problem |