That would transfer 50,000 records to the Web server.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Brad Haas
Sent: 15 September 2006 23:58
To: [email protected]
Subject: Re: [Reactor for CF] Aggregate Functions in Gateways
Kevin,
I haven't followed this thread, so forgive me if I'm misunderstanding
the situation. If you're wanting a record count, why not do this:
Page_Gateway = Reactor.createGateway("MyTable")
pages = Page_Gateway.getAll()
qRecordCount = pages.RecordCount
Is this what you want or where you looking to not convert the gateway
to an actually query?
--Brad
On Sep 15, 2006, at 6:25 PM, Kevin Roche wrote:
> Well I did not get any positive answers from anyone on the list
> about doing
> a COUNT(*) so I thought you my like to know what to do should you
> need to do
> this.
>
> // First we must set up the Reactor Factory.
> Reactor = CreateObject("Component",
> "reactor.reactorFactory").init(expandPath("reactor.xml"));
>
> // Then we create the gateway object.
> Page_Gateway = Reactor.createGateway("MyTable");
>
> // Then we create the Query object.
> Query = MyTable_Gateway.createQuery();
>
> // Create a field to use using an exsiting column
> Query.returnObjectFields("MyTable","SomeColumn");
>
> // Set up the Count
> Query.setFieldExpression("MyTable","SomeColumn","COUNT
> (*)","CF_SQL_INTEGER")
> ;
>
> qRecordCount = MyTable_Gateway.getByQuery(Query);
>
> Unfortunately I can yet see how to set up a GROUP BY clause so
> watch this
> space ......
>
> Kevin Roche
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Behalf Of Kevin Roche
> Sent: 14 September 2006 23:25
> To: [email protected]
> Subject: [Reactor for CF] Aggregate Functions in Gateways
>
>
> 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/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -
> - --
>
>
>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- --
> Reactor for ColdFusion Mailing List
> [email protected]
> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- -- -- -- --
>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
