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 (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
