In insert file: d:\http\ns\news.htf
inserted by: d:\http\ns\news.html ;; near line number 53
;; following starts near line 53 in your source form...
...
{sql to prenewsresults source 'LINEX_LINKS' user '' password '' }
SELECT tblNews.News_Text, tblNews.News_name, tblNews.Image_Caption, tblNews.Contact_Name, tblNews.Contact_eml, tblNews.Contact_phone, tblNews.city, tblNews.state, tblNews.Approved, tblNews.News_Image, tblNews.NewsDate, tblNews.NewsID
FROM tblNews
WHERE (((tblNews.Approved)=Yes))
AND (((tblNews.SortDate)>#{LastDate}#))
ORDER BY tblNews.SortDate DESC;
{/sql}
{if prenewsresults isNull}{! means no previous news !}
{else}
...
**