Forum OpenACS Q&A: Adding News headers on the Front Page

Hi to all reading, know there was allready a post but i do not seem to get it work.
All files are put in the ../www/ folder and from the main page (index.adp) i put :
include src="newsopenacs" .... When try to view the page i get an error :
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.") while executing "ns_pg_bind 0or1row nsdb0 { select decode(count(*),0,0,1) from news_items_approved where publish_date < sysdate and archive_dat..." ("uplevel" body line 1) invoked from within
if i use the same idea as the original message i read from wich is : include src= "(this should be my file name)" type="@type@ archive_interval="@interval@" archive_date="@archive_date@" ..... The error states that can't read "type": no such variable

If i'm wrong please correct me coz have been for a long time with the problem.
Thanks in Advance.
Collapse
Posted by Eric Wolfram on
Are you trying to get the OpenACS news on your front page, or are you trying to get your own news on your own front page?

If you want your own news, grab the news tcl and adp file for the OpenACS dev server at:

http://dev.openacs.org:8000/cvs/openacs.org-dev/www/templates/widgets/

Then look at the ../homepage-index.adp file to see how those "widgets" are included.

Cool.
e