%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "1" If (Request.QueryString("ID") <> "") Then Recordset1__MMColParam = Request.QueryString("ID") End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_PBBMember_STRING Recordset1.Source = "SELECT * FROM MemNotes WHERE ID = " + Replace(Recordset1__MMColParam, "'", "''") + "" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %>
|
Note: <%=(Recordset1.Fields.Item("Headline").Value)%> |
|
<%=UCase((Recordset1.Fields.Item("Headline").Value))%>
<% NoteText=(Recordset1.Fields.Item("NoteText").Value) NoteText=replace(NoteText,vbcrlf," ") %> <%=NoteText %> Entered by: <%=(Recordset1.Fields.Item("EnteredBy").Value)%>
Created on <%=(Recordset1.Fields.Item("CreateDate").Value)%>, last edited on <%=(Recordset1.Fields.Item("EditDate").Value)%> |