Re: Getting the result of a query using COUNT(*)

"Jackson Ching" <jching@imvi.com.ph> writes:
>     SELECT COUNT(*) FROM MyTable

>     in my rs.getint("COUNT(*)");

Offhand I'd guess that the returned column heading is "count" not
"COUNT(*)".  Use an AS clause if you want to be sure about the
column heading of a SELECT result...

            regards, tom lane