%@LANGUAGE="VBSCRIPT"%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_twinoaks_STRING
Recordset1.Source = "SELECT * FROM LOISLINKS ORDER BY linkID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
Lois Scott's Favorite links
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
| " target="_blank"><%=(Recordset1.Fields.Item("linkTitle").Value)%> |
|
| |
<%
Dim MyText
MyText = Recordset1.Fields.Item("linkDesc").Value
MyText =Replace(MyText,vbcrlf," ")
Response.write MyText
%>
|
|
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
|
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>