we use the following to pull all events that are within the next 30 days.
WHERE tblEventDate.intLocationIDFK = tblEventLocation.intLocationID
AND
(tblEventDate.dteEventDate > now()) and
(tblEventDate.dteEventDate < now()+30)
Using this method we only have 1 date in the DB, the date of the actual
event.
With this in mind, I guess you could put Sundays date for the week you want
the info to run and change the above to <= now() and > now() - 6.
This way the user says "I want this info to run the week of Sunday the 22 so
that's the date they put in. You could obviously make it Monday or whatever
makes sense.
PS you probably would have had many more responses to this if you would have
posted this on CF-Talk.
HTH
Stephen
-----Original Message-----
From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 2:14 PM
To: CF-Server
Subject: Weekly Date Driven Content in Cold Fusion?
Is there a way to do a date range from start to end (e.g. a five day span)?
I want to be able to have content automatically change every week from
information being stored in a database. The information will be displayed
only if it falls within that date range criteria (I would build two fields
"start_date" and "end_date".
Is something like this possible in Cold Fusion?
TIA,
Dayv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
