Anybody out there know how to do an Aggregate function in a Reactor Gateway?
For example I want to do somthing like...
SELECT COUNT(*) FROM myTable
It seems to me that setFieldExpression should do it but I have tried a few
things and they don't work.
For example:
Query.setFieldExpression("myTable","RC","COUNT(*)","CF_SQL_INTEGER");
doesn't produce anything in the resuling SQL. What am I doing wrong?
Kevin Roche
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
