> Hello again -
>
> It seems as though my reasoning is not working out after all. The
> queries that I am using to get a list of upcoming events is:
>
> <cfquery name="getEvents" datasource="myDSN">
> SELECT id, unit, date, description, title, day, time, location, max,
> excludeReg
> FROM EVENTS
> WHERE
> (((unit='CTL' or unit='Special' or cosponsor like '%CTL%') and date >=
> #now()# and approved=YES and advertiseWeb=YES) or
> ((unit='CTL' or unit='Special' or cosponsor like '%CTL%' or cosponsor
> like '%IUSM%') and date Is Null and approved=YES and
> advertiseWeb=YES))ORDER BY date asc
> </cfquery>
>
> This is the query to count the number of attendees registered for the
> event:
>
> <cfquery name="getAttendance" datasource="myDSN">
> SELECT count(eventID) as eventCount
> FROM EventAttendance
> WHERE eventID = <cfqueryparam cfsqltype="cf_sql_integer"
> value="#getEvents.id#" />
> </cfquery>
>
> (The eventID is added to the table each time someone registers for the
> event.)
>
> This is a portion of the content of the page that includes the queries
> and logic to determine if the event has met its maximum number of
> available seats:
>
> <cfoutput query="getEvents">
>
> <p><strong>#title#</strong></p>
> <cfif getAttendance.eventCount GTE getEvents.max>
> <p class="eventFull">Event Full</p>
> <cfelse>
> </cfif>
> </p>
> <p>When: #DateFormat(date, "full")# | #time# <br />
> Where: #location#</p>
> </cfoutput>
>
> With the way the code is now, events that hold 100 people are
> appearing full with just two people registered. I have looked over my
> queries and don't see any apparent error. Could someone lend another
> set of eyes and insight as to what may be wrong?
>
> Thanks,
> Adam
would getEvents.max be a problem? Is max a reserved word? The calculation
appears to be off.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:4488
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
