MelvinK
|
| Posted: 08/06/2003, 5:12 AM |
|
Hi Everyone,
I've got a little question where you guys may be able to help me with.
I'm building a news system with CC (not CCS) and I want articles to be displayed on the frontpage depending on what date their expiration date is set to.
So lets say I add an article to my database with an expiration date of 10 August. I want it to be viewable untill/upto 10 august and then be gone on 11th of august. I also want the articles to be replaced by newer articles when these are made.
Does anyone of you have experience with setting this up? I'm not really an ASP programmer but I found CC very easy to use and setup various webforms for our company.
So If anyone can help me they can either post it here or email me at
MelvinKrone@hotmail.com
|
|
|
 |
RonB
|
| Posted: 08/06/2003, 5:29 AM |
|
Use sql to make the selection:
select * from news_table where news_exp_date >= now()
Ron
|
|
|
|
MelvinK
|
| Posted: 08/06/2003, 6:45 AM |
|
thanks for your swift response
|
|
|
|
|
