Dynamic output by calendar date?

[KidKodiak]

Hi all,

Here's my latest dilemma. I'm creating a website for a church, and one of the
features they're requesting is a weekly sermon schedule. I've build the SQL DB
with the appropriate information for the next 6 months worth of data, however
if possible I'd like to get that data populated automatically to a CF Template
for the specific week of the sermon, so that manual updates aren't required.

I know I can create columns for the week or date of the sermon, however I'm
not sure what vehicle will call the correct entry for the specific week , and I
can't seem to find any information on the web to help =\

This isnt' a request to mooch free code... I just need help understanding the
logic that would create a function like this, if its even possible, as I'm
still pretty new with CFML and am cramming much of it in on an as-needed basis
for this project =)

Any help is appreciated!

[mxstu]

If I'm understanding you correctly, you want your CF page to display the next
sermon, based on the current date. So if today were 6/24/2005 and the next
sermon was scheduled for 06/26/2005, you would like to display the sermon for
06/26/2005.

You could create a CFQUERY and pass the current date as parameter. Then use
CFOUTPUT as usual to display the results. This is just an example and the
exact syntax depends on on how your data is stored, but it should give you a
starting point.



<!--- Assumes SermonDate is a date/time field that contains a date only --->
<cfset todaysDate = Now()>
<cfquery name="getSermons" datasource="yourDSN">
SELECT SermonID, SermonDate, Topic, Description
FROM Sermon
WHERE SermonDate = (
SELECT MIN(SermonDate)
FROM Sermon
WHERE SermonDate >= #CreateODBCDate(todaysDate)#
)
</cfquery>

[KidKodiak]

Hi! Yes, that's the right idea, and I'll look at your code and try to figure out what I need to do, thank you for taking the time to reply! =)

[mxstu]

You're welcome. Querying "date" fields can be a bit tricky at first, so feel free to post back if you have any questions and I'm sure somebody can help.