%
' The following is the code for the scrolling news ticker. This will only work on a IIS server and IE browsers. Netscape users will still see the news, but it will not scroll.
Dim sTxt, iSpeed, iTop, iLeft, iWidth, iHeight, sHtml1, sHtml2, sHtml4, strSQL,sMarquee
Dim conCurrent
Dim rstCurrent
Set conCurrent = CreateObject("ADODB.Connection")
Set rstCurrent = Server.CreateObject("ADODB.Recordset")
conCurrent.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=c:\inetpub\wwwroot\noida\new\news.mdb"
strSQL = "SELECT * FROM news ORDER BY Entry_Date DESC"
Set rstCurrent = conCurrent.Execute(strSQL)
sHtml1 = "
"
sHtml3 = "'>"
sHtml4 = "
"
sTxt = ""
rstCurrent.movefirst
do while not rstCurrent.eof 'I used variables here to try and reduce this long assignment
sTxt = sTxt & sHtml1 & sHtml2 & _
rstCurrent("Entry_ID") & sHtml3 & rstCurrent("Title") & sHtml4
rstCurrent.movenext
loop
iSpeed = 1 ' Speed of Marquee (higher = slower)
iTop = 0 ' Y Location Within Object
iLeft = 0 ' X Location""""
iWidth = 140 ' Width
iHeight = 200 ' Height
'Insert marquee into objects innerHtml Property (in this Case a table cell)
sMarquee=""
conCurrent.close 'Don't forget to clean-up!
set conCurrent = Nothing
%>
 |
|
|
 |
¤
CityEvents ¤ |
 |
| S.no |
Date |
Details |
| 1. |
8 dec 2005 |
YMCA to address disability concerns in Greater
Noida. |
| |
| *
You can also contribute in this section by sending
event information at noidaevents@DekhNoidaDekh.com
or call us at 9811632823 |
| |
|
|
|
| |
|
|
*
programs & schedules can be changed without prior notices.... |
| |
|
|