News Scroller - Pls help !!

[jeswin12]

My requirement is that i have two sections Admin and User -

Admin: textbox to add NEWS to MS SQL database.

User: News scroller that reads the news from the database and displays (scrolls) it

Both admin and user page is done in ASP.

Pls post me the script or a link where i can get a script that can read the values from MS SQL db and scroll it.

example site: http://www.ndtv.com/homepage/default.asp (see the top, i need a similar scroller that can read from a db) i dont want the button.. just simple message (one by one) scroller would do..

thanks in advance...

[Bullschmidt]

Here's an example scroller showing a field called Scroller from an open recordset:

<marquee style="background-color:#FFFFFF; font-size:10pt; font-weight:bold" scrollamount="10"><%= objRS("Scroller") %></marquee>

And here are a couple scroller links:

FearBy.com Tutorials - Marquees
http://jane.fearby.com/tutorials/marquee.html

Lissa Explains It All - How do I make a scrolling marquee?
http://www.lissaexplains.com/fun3.shtml

And for some short database examples:

www.asp101.com/samples