Multiple Counts within a Find?

[billiam02]

I'm trying to set up a calendar which lists dates that take place within a month. The calendar will list the event day (In Two Seperate Fields 'Event_Month' and 'Event_Day'). This is an educational calendar and have a field set to catagorize the type of event being listed. I've got it set up so that when you visit the calendar's main page, it's got CDML links to view the different months:

http://208.239.203.98/FMPro?-db=2.fp5&-format=Calendarweb.html&Event_Year=2002&Event_Month=March&-Max=14&-SortField=Event_Date&-SortOrder=acsending&-Error=error.html&-Find

This is to a dynamic IP for now, but that's the code. I want to do a count at the top of each individual month's page that says that will display a count of the number of records within the seperate catagories. (I.E. the number of school days off, etc). I'm pretty confused, and still in the process of learning this stuff... any help would be appreciated!

[Keith M. Davie]

"I'm trying to set up a calendar which lists dates that take place within a month."

"I want to do a count at the top of each individual month's page that says that will display a count of the number of records within the seperate catagories."

In either of the following possible solutions I believe you will need to do at least one find within a date range for the month in question.

1. If you had separate db files for each category you could use inlineactions to get a currentfoundcount for each category.

2. To display each catagory's found count you must perform a find for each catagory. And you must capture each currentfoundcount along the way as a token which can be displayed.

Perhaps someone else has some ideas.