Updating an entry based on a certain date

[jhilltektips]

Hello,

Can I do this? And how?
I want the user to be able to view a certain web page for a duration of 7 days.
The user is allowed to enter into my SQLServer70 table the day they want to start viewing the page.
Based on the date entered, the preexisting URL (

http://myserver/nopage.htm)

will be updated to

http://myserver/somepage.htm,

so they can view it, then in 7 days be updated back to

http://myserver/nopage.htm.

I am assuming this is the best way to do this if it is possible in CFusion5 and SQLServer7...

any suggestions??

thanks,
Jason