Next step: running complex queries that return counts
Next step: running complex queries that return counts
- Subject: Next step: running complex queries that return counts
- From: Ken Anderson <email@hidden>
- Date: Thu, 20 Oct 2016 11:39:48 -0400
All,
Now that I have a good idea about charting, I now need to build the values that will be used for the charts. Because of the volume of data, this will be a new entity that will have a bunch of totals computed and stored.
To generate the values, I need to run SQL selects that will return counts for me to store. Something like this:
select count(distinct friendID) from MemberFriend where id in (select distinct memberFriendID from Fitlove where occurredAt between '2016-10-19 00:00:00' and '2016-10-19 23:59:59');
In searching around, it seems like ERXSQLQueryWithBindingsUtilities.rawRowsForSqlWithBindings would be perfect, but I have no idea how to generate the correct query and to setup the binding properly (using mysql 5.5).
Can anyone point me to some resources for doing raw rows with bindings with mysql?
Thanks!
Ken
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden