%Option Explicit%> <% Dim strLoggedIn If Session("Authenticated") = True Then strLoggedIn = True 'Else ' Response.Redirect "logerr.asp" End If %>
|
imaginekb.com | Journal | Members | Pictures | About | Calendar | Interests Imaginekb Sidebar Recent Journal Entries: <%
'***********************
' Simple Sample *
'***********************
' James Journal *
' Is Date Specific *
'***********************
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.ActiveConnection = strConnect
objRS.CursorType = adOpenStatic
objRS.LockType = adLockReadonly
objRS.Source = "SELECT date, body, public FROM jamjournal WHERE public Like True ORDER BY Date DESC"
objRS.Open
While NOT objRS.EOF
If objRS("public") =True And objRS("date") > Now -15 Then
Response.Write "James' Journal " End If objRS.MoveNext Wend objRS.Close Set objRS = Nothing %> <% '*********************** ' Simple Sample * '*********************** ' Kevin's Journal * ' Is Date Specific * '*********************** Set objRS = Server.CreateObject("ADODB.Recordset") objRS.ActiveConnection = strConnect objRS.CursorType = adOpenStatic objRS.LockType = adLockReadonly objRS.Source = "SELECT date, body, public FROM kjournal WHERE public Like True ORDER BY Date DESC" objRS.Open While NOT objRS.EOF If objRS("public") = True And objRS("date") > Now -2 Then Response.Write "Kevin's Journal " & objRS("date") &"" & " " & objRS("body") & " " &_ "View entire Journal" &_ " " End If objRS.MoveNext Wend objRS.Close Set objRS = Nothing %>
|