<%
set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
baza = Server.MapPath("../baze/Besede.mdb")
objConn.open baza
'****strSQL = "SELECT * FROM Oglasi ORDER BY Datum DESC"
strSQL = "SELECT * FROM Oglasi ORDER BY Id DESC"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn
'*****
Do While Not objRS.EOF
%>
<%
Response.Write "
"
Response.Write "
#"&objRS("Id") &"
"
Response.Write "
"&objRS("Potpis") &"
"
Response.Write "
"&objRS("Email") &"
"
Dim encode_txt
encode_txt=objRS("Text")
encode_txt=Server.HTMLEncode(encode_txt)
Response.Write "
"&encode_txt&"
"
Response.Write "
"&objRS("Datum") &"
"
Response.Write "
"&objRS("Vrijeme") &"
"
Response.Write "
"&objRS("Mjesto") &"
"
Response.Write "
"
objRS.MoveNext
%>
<%
Loop
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>