<%@Language = "VBScript"%> <% 'create db connection Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Data Source=" & Server.MapPath("db/ivy.mdb") &";Provider=Microsoft.Jet.OLEDB.4.0;" %> <% Dim status status = "" status = Request.QueryString("status") cutoff = DateAdd("d", -30, date()) thismonth = month(date()) thisyear = year(date()) if thismonth = 12 then nextyear = dateadd("yyyy", 1, thisyear) else nextyear = thisyear end if firstofthismonth = thismonth & "/1/" & thisyear firstofnextmonth = dateAdd("m", 1, firstofthismonth) SQL = "SELECT * FROM blog WHERE DateEntered >= #" & cutoff & "# ORDER BY DateEntered desc" Set RS = Conn.Execute(SQL) %> Alexandra Ivy - Blog

Return to Home

 

Books

About Alexandra

Latest News

Bonus!

Links

Blog

List of Characters

Email Alexandra

 

 

 

Blog

Login

<%if status = "done" then%>

Your comments have been saved and will be posted as soon as they are approved.

<%end if%> <%if status = "remove" then%>

Your comments were not allowed.

<%end if%>

Come read my blog and let me know what you think.  Take the time to read my previous entries as well.

<%if not RS.Eof then %>
<%do while NOT RS.EOF entry = replace(RS("entry"), "''", "'") entry = replace(entry, "

", "

") topic = replace(RS("topic"), "''", "'") if not isNull(RS("alignment")) then alignment = RS("alignment") else alignment = "" end if if NOT isNull(RS("img")) then imgsrc = RS("img") else imgsrc = "" end if if not isNull(RS("imgsize")) then width = RS("imgsize") else width = "" end if if NOT isNull(RS("caption")) then caption = replace(RS("caption"), "''", "'") else caption = "" end if%>

<%RS.MoveNext Loop%>

<%=RS("DateEntered")%>

<%=topic%>

<% if imgsrc <> "" then%>
<% if caption <> "" then%>

<%=caption%>

<% end if%>
<%end if%>

<%=entry%>

">Enter comments

<%SQL2 = "SELECT * FROM Comments WHERE BlogID = " & RS("BlogID") & " AND approved = 'yes'" Set RS2 = COnn.Execute(SQL2) if not RS2.EOF then%>

Comments:

<%do while NOT RS2.EOF%>

<%=RS2("comments")%>

Posted  by "><%=RS2("firstname")%> <%=RS2("lastname")%> on <%=RS2("dateentered")%>

<%RS2.MoveNext Loop end if RS2.close set RS2 = nothing%>
 
<%else%>

There are no entries.

<%end if%>

To read previous entries, click here.

HOME  ||  BOOKS  ||  BIO  ||  NEWS  ||  BONUS!  ||  LINKS  ||  BLOG  ||  CHARACTERS  ||  EMAIL

 

Website property of Deborah Raleigh/Alexandra Ivy.
Copyright ©2007 Deborah Raleigh. All Rights Reserved.
For problems, contact the
webmaster