[ic] Timed news_feature doesn't work

[Douglas Smith]

Sorry to chime in but who the heck are you people and why am I suddenly 
getting e-mails about whatever it is that you guys are speaking about?  
Are you computer programmers?
On May 27, 2004, at 8:18 AM, Rene Hertell wrote:

>> Hi all,
>>
>> I use the /eg news_feature files deliverd with the foundation store. I
>> created the mysql news table and use the standard pages and
>> template files.
>>
>> It works great but the timed_news function doesn't work. The date
>> (Start and
>> End) is displayed correctly in the mysql table and in the field
>> timed_news=1. So everything seems to be right.
>>
>> Is there anyone who can tell me how I can let the 
>> start_date/finish_date
>> work.
>
> First you have to store a start and end date in that field, like 
> 20040527
> and 20040531. After that you create a query that checks those dates 
> with the
> current date: select * from news where start_date > [scratch 
> current_date]
> and finish_date < [scratch current_date]  (untested)
>
> You set the current_date to a scratch like this:
>
> [seti current_date][time]%Y%m%d[/time][/seti]
>
>
> René
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>