<% function spChars(myValue,in_out) spChars = replace(myValue,"|","'") end function function getNewsList() Set MyConn = Server.CreateObject("ADODB.Connection") MdbFilePath = Server.MapPath("database/hounddog.mdb") MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";" set oRS = myConn.execute("select * from news order by stamp desc") s = s & "" s = s & "" do while not oRS.eof s = s & "" oRS.movenext loop s = s & "
Date    Title
" & right(oRS("stamp"),2)&"-"&monthName(mid(oRS("stamp"),5,2),true)&"-"&left(oRS("stamp"),4)& "    " & spChars(oRS("title"),"out") & "
" getNewsList = s end function %> Hound Dog Website