From: | "Alexander Farber" <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | libpq: bind message supplies 2 parameters, but prepared statement requires 1 |
Date: | 2006-07-02 21:17:12 |
Message-ID: | 943abd910607021417r12f33780ld4ac9bed7b9c5bdc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
these 2 statements work fine for me on the psql-prompt:
punbb=> select id, username, md5('deadbeef' || password) from users
where id = 7;
id | username | md5
----+----------+----------------------------------
7 | Alex | b962415469222eeb31e739c3afbc8a4a
(1 row)
punbb=> select username from users where id = 7 and md5('deadbeef' ||
password) = 'b962415469222eeb31e739c3afbc8a4a';
username
----------
Alex
(1 row)
However when I try to execute the latter query by my C-program,
then it fails, saying that my bind command supplies 2 arguments
(yes, that's true), but the prepared statement requires 1 argument
(why 1? I don't understand). I have prepared a separate simple
test case, could someone please explain what am I doing wrong?
#include <err.h>
#include <stdio.h>
#include <libpq-fe.h>
#define DB_CONN_STR "host=/var/www/tmp user=punbb dbname=punbb"
#define SQL_FETCH_USERNAME "select username from users " \
"where id = $1 and md5('deadbeef' || password) = '$2'"
int
main(int argc, char *argv[])
{
PGconn* conn;
PGresult* res;
const char *args[2];
char username[201];
if ((conn = PQconnectdb(DB_CONN_STR)) == NULL)
err(1, "Connect to '%s' failed: out of memory", DB_CONN_STR);
if (PQstatus(conn) != CONNECTION_OK)
err(1, "Connect to '%s' failed: %s",
DB_CONN_STR, PQerrorMessage(conn));
if ((res = PQprepare(conn, "sql_fetch_username",
SQL_FETCH_USERNAME, 2, NULL)) == NULL)
err(1, "Preparing statement '%s' failed: out of memory",
SQL_FETCH_USERNAME);
if (PQresultStatus(res) != PGRES_COMMAND_OK)
err(1, "Preparing statement '%s' failed: %s",
SQL_FETCH_USERNAME, PQerrorMessage(conn));
PQclear(res);
args[0] = "7";
args[1] = "b962415469222eeb31e739c3afbc8a4a";
if ((res = PQexecPrepared(conn, "sql_fetch_username",
2, args, NULL, NULL, 0)) == NULL)
err(1, "Executing statement '%s' failed: out of memory",
SQL_FETCH_USERNAME);
if (PQresultStatus(res) != PGRES_TUPLES_OK)
err(1, "Executing statement '%s' failed: %s",
SQL_FETCH_USERNAME, PQerrorMessage(conn));
PQclear(res);
PQfinish(conn);
return 0;
}
And here is the error message I get:
laptop72:src {541} ./fetch-user
fetch-user: Executing statement 'select username from users where id =
$1 and md5('deadbeef' || password) = '$2'' failed: ERROR: bind
message supplies 2 parameters, but prepared statement
"sql_fetch_username" requires 1
: No such file or directory
Thank you
Alex
PS: Using Postgresql 8.1.0 (from packages) on OpenBSD/386 -current
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-07-02 21:26:56 | Re: different sort order in windows and linux version |
Previous Message | Tomi NA | 2006-07-02 21:14:54 | Re: different sort order in windows and linux version |