All I want is a No Results Found message when no data is found.
When no data is found in my HTML view, I want my own message that says so and explains what to do next. I know how to do this if a view is simple, but mine is not.
I will explain my problem, and here is the page in question, http://www.slaafws.org/meetings :
1. My database has TWO forms for two different types of groups with BOTH form views displayed on the same HTML page.
2. The two types of groups are searched simultaneously by dropdown by country and state for US and Canada, BUT only country everywhere else.
3. For countries other than the USA and Canada, getting the no data found message is easy. if group1's and group 2's input.country count is 0 and group1's and group2's input.state count is 0, then display the no results message. That part works.
Here is the if portion of that code which triggers the no results message:
- <%if ((((count(intergroup_registration[GroupCountry == input.Country]) < 1) && (count(NEW_Group_Registration[GroupCountry == input.Country]) < 1)) && (count(intergroup_registration[StateSelect == input.State]) < 1)) && (count(NEW_Group_Registration[StateSelect == input.State]) < 1))
4. My problem is the USA and Canada. If I search on, say, Alabama, there are no groups there of either type, so the state part of the code flies. But the country portion does not, since all US states share the same country. The message does not display.
Isn't there an easier way to do this? Like if both views return empty, no matter what is searched for, display the message? I really need some help.
Thanks