Result count of a select cache query in UCM

We have written a Select cache query in UCM. The purpose is to retrieve the count of documents from the revisions table that match a particular criteria. A custom service has been created on this query. This custom service is being called into a wsdl The query is working fine in jdev but somehow we are unable to write the results into a field that can be returned by the wsdl. Is there any way to return the count of results obtained by the query into a wsdl?

Any pointers are appreciated.

Thanks