Message-ID: <003301c45f71$8187cb80$8616b1cb@cache>
Reply-To: "apellido jr., wilfredo p." <apellido@mactan.ph>
From: "apellido jr., wilfredo p." <apellido@mactan.ph>
To: "Nigel J. Andrews" <nandrews@investsystems.co.uk>
Cc: <pgsql-interfaces@postgresql.org>
Subject: Re: help !!!
Date: Thu, 1 Jul 2004 21:43:47 +0800

 Hello Sir, thanks for reply.  Im just testing what you said and i got this
 error:

Enter Username:  apellido
 Username :  apellido
 Grade : (null)

-----------------------------
 my code:


double    i;
char       *reply_string;

reply_string = PQgetvalue(res, 0, 1);
  i = strtod(reply_string,NULL)/2.0;


Sir, i know that PQgetvalue(res, 0, 1); will return number although it is
 declare in the field varchar. Im already test

int i;                (also  tried unsigned short int)

reply_string = PQgetvalue(res, 0, 1);
 i = strtoul(reply_string,NULL, 3)/2.0;

Still i got the same error...  Im googling how to convert ascii to integer
 and i saw another question which confused me: here it is


Is there a command that can be used to temporarily convert a string value in
 a field to integer?

I.E.

SELECT name, employeeid
 FROM users
 WHERE employeeid = bob

In this case employeeid is an integer, and bob is a number but stored as a
 string.  how do you temporarily convert bob to an integer for the sake of
 the comparison?