%@ LANGUAGE=VBSCRIPT %> <% Option Explicit %>
Link |
|
Preporuka | ||||||||||||
<% objConn.Close Set objConn=Nothing 'Dim objConn, kao Set objConn=Server.CreateObject("ADODB.Connection") objConn.ConnectionString= "DSN=rezerva" objConn.open pizda= "SELECT * FROM vjesti WHERE preporuka = true ORDER BY datum DESC" Set objRS=Server.CreateObject("ADODB.Recordset") objRs.Open pizda, objConn Do While Not objRS.EOF %>
<%
'response.write (objRS("Naslov")&"")
objRS.MoveNext
loop
objConn.Close
Set objConn=Nothing
'Dim objConn, kao
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString= "DSN=Ivan.dsn"
objConn.open
%>
|
||||||||||||||
SLIENI TEKSTOVI |
DNEVNIK |
|||||||||||||
Galerija fotografija <% dim cuca cuca= "SELECT * FROM citati WHERE datum>= Date()-7 ORDER BY datum DESC" dim objRSc Set objRSc=Server.CreateObject("ADODB.Recordset") objRsc.Open cuca, objConn 'dim n 'n=1 'response.Write(vrsta) Do While Not objRSc.EOF SetLocale("hr") %> " target="_blank"><%=objRSc("Naslov")%>
<% Response.Write(" - " & objRSc("Od")& " - " & FormatDateTime(objRSc("Datum"),0))%>
<%
objRSc.MoveNext
loop
objRSc.Close
Set objRSc=Nothing
'Set objConn=Nothing
%>
|
<%
dim pizda
pizda= "SELECT * FROM vjesti WHERE year(datum) > '2022' ORDER BY id DESC"
//pizda= "SELECT * FROM vjesti WHERE id > 530"
dim objRS
Set objRS=Server.CreateObject("ADODB.Recordset")
objRs.Open pizda, objConn
dim nn, arhiva
dim xy
xy=1
nn=1
nas=1
arhiva=Request("Arh")
if arhiva = 0 then
arhiva=objRS("id")
else
arhiva=Request("Arh")
end if
SetLocale("hr")
Do While Not objRS.EOF
if cdbl(objRS("id"))=cdbl(arhiva) then
if xy<=3 then
arhiva=arhiva-1
else
arhiva=10000
end if
xy=xy+1
response.write(" "&FormatDateTime(objRS("datum"),1)&" "&"") response.write(" "&""&objRS("naslov")&""&" "&"") dim nas, broji nas=objRS("id") Response.write(" "&objRS("vjesti")&"
") 'http://ivan-hrvacic.iz.hr/pregled.asp?Arh=328&ArhTag=agrokor %> Tag: & Arh=<%=objRS("id")%>" class="style42"><%=objRS("tag")%>
<%
broji=0
Do While Not objRSpor.EOF
if objRSpor("tema")= nas then
broji=broji+1
response.write ("
<%
Dim idee
idee=0
broji=0
Do While Not objRSpor.EOF
if objRSpor("tema")= cdbl(idee) then
broji=broji+1
response.write (" |
ARHIVA
<%
if objRS("id")="" then
objRS.MoveNext
else
response.write (objRS("id") &"." )
end if
%>
&ArhTag=<%=objRS("tag")%>" target="_blank" class="style41"><%=objRS("naslov")%>
")
response.write(" *Komentara("&broji&")"&"")
else
response.write(" ")
response.write(" *Komentara("&broji&")"&"")
end if
objRS.MoveNext
loop
objRS.Close
%>
|