%@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) %>
![]() |
|||||||||
|
|
|||||||||
|
|
|
||||||||
|
|
HOME || BOOKS || BIO || NEWS || BONUS! || LINKS || BLOG || CHARACTERS || EMAIL |
||||||||
|
Website property of Deborah
Raleigh/Alexandra Ivy. |
|
|