Hello,
I've got a question, I want to be able to post some content for a five day
time span from a database and then have it removed. What Cold Fusion Tag
would be used to accomplish this? I've got as far as being able to display
the content daily, but the next day it expires and shows up as a blank page.
For reference I am including my code in hopes that one of you may know of a
way to add a few lines that would accomplish this....
<snip>
<cfquery name="weekly" datasource="temp">
select * from weekly
where
The_Date_Span = (select max(The_Date_Span)
from weekly
where
The_Date_Span <= #createodbcdate(now())#)
</cfquery>
<cfoutput query="weekly">#Content#<br>#Footnote#</cfoutput>
</snip>
As of now, I am using a database with one field labeled "The_Date_Span". I
would like the content that falls between this day (e.g. a five day work
week; Monday-Friday) to be displayed if it falls within this criteria.(if
you require my database fields for add'l reference, let me know).
Is this possible or do I need to create a start_date/end_date field. I
wasn't able to get it to work before....
Again, any assistance with this would be most appreciative!!
Dayv
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
