From: apellido jr., wilfredo p. <apellido@mactan.ph>
To: pgsql-interfaces@postgresql.org
Subject: help !!!
Date: Wed, 30 Jun 2004 21:26:06 +0800
Message-ID: <000b01c45ea5$def68850$8616b1cb@cache> (raw)
Hello! im a newbie in C programing as well as Postgresql. The above example
is workin but im having difficulty regarding assigning the result of Query
Select. here's the program
int
main()
{
char UserName[50]; /* holds user
state code */
char query_string[256]; /* holds
constructed SQL query */
PGconn *conn; /* holds
database connection */
PGresult *res; /* holds
query result */
conn = PQconnectdb("dbname=grade"); /* connect
to the database */
if (PQstatus(conn) == CONNECTION_BAD) /* did the
connection fail? */
{
fprintf(stderr, "Connection to database failed.\n");
fprintf(stderr, "%s", PQerrorMessage(conn));
exit(1);
}
printf("Enter Username: "); /* prompt user
for a state code */
scanf("%s", UserName);
sprintf(query_string, /* create an
SQL query string */
"SELECT username, value
FROM table1
where test = 'grade' and username = '%s'", UserName);
res = PQexec(conn, query_string); /* send the
query */
if (PQresultStatus(res) != PGRES_TUPLES_OK) /* did the
query fail? */
{
fprintf(stderr, "SELECT query failed.\n");
PQclear(res);
PQfinish(conn);
exit(1);
}
printf("\n\n\n");
printf("Username : %s\n\n\n", PQgetvalue(res, 0, 0));
printf("Grade : %s \n\n\n", PQgetvalue(res, 0, 1));
PQclear(res); /* free
result */
PQfinish(conn); /*
disconnect from the database */
return 0;
}
############################################################################
########
hello how can i assign to certain variable the output of PQgetvalue(res, 0,
1)? example i want to do like this ...
a = PQgetvalue(res, 0, 1)
printf("Grade : %s \n\n\n", a );
and then after assigning the value of PQgetvalue(res, 0, 1) to a then ...
b = a \ 2;
but it is possible to divide the output of "a" where it is a var and "b" is
integer?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: apellido@mactan.ph
Subject: Re: help !!!
In-Reply-To: <000b01c45ea5$def68850$8616b1cb@cache>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox