Automatic Query Updates

Hi

I am new to Coldfusion and need assistance writing a simple query. I am using Coldfusion/Sql to output dates from my calendar database. Right now I am updating my events weekly withing the calendar. So my query looks like this:

<cfquery name="calendar" datasource="">
SELECT * FROM calendar
Where months = 'April'
and dates > 4
and dates < 7
order by dates asc
</cfquery>

How would I be able to write a query that looks for the next value automatically and limits the number of results, instead of me having to punch in numbers manually every week?

Thanks for the help

It would be easier if you had just the week in the year, which would just be #Week(Now())#, but try this:

<cfif DayOfWeek(Now()) EQ 1><cfset firstday = DateFormat(Now(),"d")>
<cfset lastday = DateAdd("d",6,Now())>
<cfelse><cfset firstday = DateAdd("d",(DayOfWeek(Now())-1)*-1),Now())>
<cfset lastday = DateAdd("d",(7-DayOfWeek(Now())),Now())>
</cfif>
<cfquery name="calendar" datasource="">
SELECT * FROM calendar
Where months = '#DateFormat(Now(),"mmmm")#'
and dates > #firstday#
and dates < #lastday#
order by dates asc
</cfquery>

You can do this by replacing the hardcoded values with function calls, and you could use either CFML functions or functions specific to your RDBMS.