Create A Calendar with a Query

[hpvic03]

What I want to do is create a calendar that displays events that are going on that day. The calendar should display the names of the days of the week at the top (and the month), then there should be the dates in rows . Under each date number should be a box with the query results in it for events that are ocurring on that day.

I know that for the queries i can use the
WHERE eventdate = #ThisDate# (that's not really a variable, i just mean that the query will display different results for each day, i don't actually know how to get this to work)
in the database i will have a field called "eventdate" which has the date of the event.

Anyway i've seen cf calendars on the internet, but none have queries. I would also like to be able to go forward and backward through months.

Anyone got any ideas? I know i have to use looping and mod to create my columns, but i don't know exactly what to do. if you have an idea, please give me some code, not just an explanation, because that won't help. I'm not asking you to write the calendar, but just some ideas with code with be awesome.

Thanks!

 

[mansii]

Here's a good start:

http://ray.camdenfamily.com/index.cfm/2005/8/31/ColdFusion-101-Building-a-Calendar

Before writing out the date, do a query based on the date and put it there.

Hope this helps.