Count Variable

[moinelli]

How do I access a count variable in a query?

For example select count(*) from phonebook where city='Seattle'

The only thing I found was the countqueryHits. Is there something I am overlooking?

Thanks

 

[jpickup]

If you alias the column, e.g.
SELECT count(*) PhoneNoCount
FROM phonebook
WHERE city = 'Seattle'

The column will be availble as a field via the FieldAsInteger method.