I believe this is a call for a custom function in your gateway.
dW
On 9/14/06, Kevin Roche <
[EMAIL PROTECTED]> wrote:
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
--
"Come to the edge, he said. They said: We are afraid. Come to the edge, he said. They came. He pushed them and they flew."
Guillaume Apollinaire quotes
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
