version 3.4.04 database type: SQL Server running on our Windows 2003 Server strConnString = "driver={SQL Server};server=xxxxxxx;uid=xxxxxx;pwd=xxxxxxx;database=xxxxxdb" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
I want to be able to output the top 5-10 topics in a forum which contains news entries to my main front website as small 'list-box' style of recent news... basically SQL code will target the SQL snitz database and extract the topic titles and create links etc
I know it can be done but cannot find anything like it (and I also do not know the snitz/SQL coding knowledge to do it )
The forum which contains the news items is set to be publicly accessible and the entries do not have any replies on them. The entries are entered by myself or our moderator and is locked so noone can change it.
Well.. I have the news.asp file working sweet (Its nice, thx Da_Simulator!) but, being a newbie at including files I'm stuck. I've spent the last month and more researching this on the net but can't for the life of me find a direct answer to what I should do next. The #include statement does not work and generates nothing on the page I'm wanting it on. I figure it's because my main website page is index.htm and HTML pages don't process SSI commands (I sure that's right). No problem there, but... how can I process an included ASP file to my main page? Or.. do I have to change the extension of my main website page from index.htm to something different and modify the windows 2003 webserver configuration?
Info;
1. main webpage ---> index.htm 2. included asp file ---> news.asp 3. I'm using a <--#include file = "news.asp" --> in a table so that the news entries go to one of my dropboxes on my website.
I'm lost but sooo close. Any guidance would be really really appreciated! :)
Topic Locked
Posted - 29 January 2005 : 22:35:53
)
