ASP Ticker with Database Access

I searched around trying to find a ticker that operates much like the one on this site to no avail. So I wrote one. It was actually quite easy.

Original Author: Brent Wenson

Inputs

You will need to change the DSN name field names to access your database. Also, change the page names to whatever want.

Assumptions

Of course, this code requires IIS or similar running on the server.

Returns

The code should be pretty self-explanatory. The database needs to contain a number field that uniquely identifies the news item, this number is what is used to create the link and pass it to the next asp page. It moves through the recordset and adds a new item for each news item in the database.
Keep in mind, the link will take the user to whatever page you specify. So you need to grab the parameter from the querystring on the next page and create code to search your database and format the data as you choose.

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 83 times

Comments

No comments have been added for this post.

You must be logged in to make a comment.