From: | "apellido jr(dot), wilfredo p(dot)" <apellido(at)mactan(dot)ph> |
---|---|
To: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | help !!! |
Date: | 2004-06-30 13:26:06 |
Message-ID: | 000b01c45ea5$def68850$8616b1cb@cache |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-06-30 13:54:50 | Re: how to execute a function directly |
Previous Message | Paul Tilles | 2004-06-30 13:04:13 | how to execute a function directly |