I need a query for populating a activity/participant list for printing. The list is feeded by two url variables:
activity_id and activity_date
The format (through my serverside scripting) for the activity_date in the drop down is:
dd mmm, yyyy
I only have know idea how to translate the Url.dateformat in to the right format in the where clause in my query. This is what I have so far:
SELECT
AL.activity_id
, AL.activity_name_home_language
, AD.activity_date
, AP.bookings_number
, P.persons
, COUNT(persons) AS total_persons
, P.first_name
, P.last_name
, P.telephone
FROM
activity_list AL
INNER
JOIN activity_dates AD
ON AL.activity_id = AD.activity_id
INNER
JOIN activity_participants AP
ON AL.activity_id = AP.activity_id
INNER
JOIN participants P
ON AP.participant_id = AD.participant_id
WHERE
AL.activity_id = 'Url.activity_id'
AND
AD.activity_date = ?????
What would be the right format?