<%SQL2 = "Select top 10 datapost, titpost, id From posts where id <> " & id & " AND autorpost = '" & autor & "' order by datapost desc" Set Rs = ConnDB.Execute(SQL2) postautor = 0 While not Rs.EOF if postautor = 0 then postautor = 1%> <div class="linha05">Outros posts do Autor</div> <%end if data2 = Rs("datapost") data = split(Rs("datapost"),"/") dia = data(0) mes = data(1) ano = data(2) if len(dia) = 1 then dia = "0" & dia end if if len(mes) = 1 then mes = "0" & mes end if if len(ano) = 1 then mes = "0" & ano end if datapost = dia &"/"& mes &"/"& Right(ano, 2)%> <div class="fonte01"></div><div class="fonte06"><font title="Data do Post"><%= datapost %></font> - <a href="../blog/post.asp?id=<%= Rs("id") %>" title="Ler o Post"> <%= Rs("titpost") %></a></div> <%data = Rs("datapost") Rs.MoveNext Wend%>
Obrigado