Hello - I am trying to determine if the maximum number of attendees has been met for an event. In one table, the maximum attendance allowed is set. In another table, the attendees are captured as well as the event id.
The relation is: Events -id * -max EventAttendance -eventID * If the total of eventIDs is greater than or equal to the event max, I want to display the event is full to the user on the list of upcoming events. Can any suggestions be provided? Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4423 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
