<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "http:" If (Request("MM_EmptyValue") <> "") Then Recordset1__MMColParam = Request("MM_EmptyValue") End If %> <% Dim Recordset1 Dim Recordset1_cmd Dim Recordset1_numRows Set Recordset1_cmd = Server.CreateObject ("ADODB.Command") Recordset1_cmd.ActiveConnection = MM_twinoaks_STRING Recordset1_cmd.CommandText = "SELECT * FROM LOISGUESTBOOK WHERE NOT gbComments LIKE ? AND NOT gbName LIKE '%MMColParam%' AND NOT gbEmail LIKE '%MMColParam%' ORDER BY gbID DESC" Recordset1_cmd.Prepared = true Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 200, 1, 255, "%" + Recordset1__MMColParam + "%") ' adVarChar Set Recordset1 = Recordset1_cmd.Execute Recordset1_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat1__numRows %> Lois Scott's Guestbook
Lois Scott's Guestbook
<% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 Recordset1.MoveNext() Wend %>
"><%=(Recordset1.Fields.Item("gbName").Value)%>
<%= DoDateTime((Recordset1.Fields.Item("gbPosted").Value), 1, 1033) %>
<% Dim MyText MyText = Recordset1.Fields.Item("gbComments").Value MyText =Replace(MyText,vbcrlf,"
") Response.write MyText %>


 
Home    Bio    Photos    Guestbook    Band Gigs    My Music    Buy Stuff    Links    Contact                 

<% Recordset1.Close() Set Recordset1 = Nothing %>