There are many different ways to approach this problem. Do you have any code that you have started that we can help you tweak to get you there?
------------------ William E. Seiter Need to have your mortgage modified? I charge no fees until I am successful, then I charge almost half the rate you would find elsewhere. Professional. Dedicated. Effective. The Easy 24/7 way to get started: http://www.goldengrove.net/ or you can call: (626) 593 - 5501 -----Original Message----- From: Adam Parker [mailto:[email protected]] Sent: Friday, March 06, 2009 11:40 AM To: cf-newbie Subject: Find Maximum 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4424 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
