ddotdukes
10-26-2006, 09:44 PM
I am trying to get the sum of all people that have a reservation to an event by the date thats in the url. Below is what I have but I only get sum of all records. I am using Dreamweaver, so the 2nd SupperDate is a MMColParam.
Here is what the Variables look like
Name Default Value Run-Time Value
MMColParam 1 Request.QueryString("SupperDate")
SELECT Sum(NumberOfPeople)
FROM SupperClubReservations
WHERE SupperDate = SupperDate
Here is what the Variables look like
Name Default Value Run-Time Value
MMColParam 1 Request.QueryString("SupperDate")
SELECT Sum(NumberOfPeople)
FROM SupperClubReservations
WHERE SupperDate = SupperDate