<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Set Conn= server.createobject("adodb.connection") DSNtest = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("dados/database.mdb") Conn.Open DSNtest Set RS= Server.CreateObject("ADODB.Recordset") if request.QueryString("id")="" then SQL = "SELECT * FROM Galeria order by id" else SQL = "SELECT * FROM Galeria where id = "& request.QueryString("id") end if RS.Open SQL, conn, 3 if RS.RecordCount <> 0 then dim v_id, v_titulo, v_subtitulo, v_noticia v_id = Rs("id") v_titulo = Rs("c1") v_descricao = Rs("c2") v_texto = Rs("c3") v_palch = Rs("c4") v_categ = Rs("categoria") v_foto = Rs("foto") end if rs.Close Set rs = Nothing Set Conex = Nothing %> <%=v_Titulo%> - <%=v_c11%> <%=v_c9%>

<%=v_titulo%>

Voltar

<%=v_descricao%>


<%=v_texto%> <% Set Conn= server.createobject("adodb.connection") DSNtest = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("dados/database.mdb") Conn.Open DSNtest Set RS= Server.CreateObject("ADODB.Recordset") SQL = "Select * From fotos where codigo ='"&v_id&"'" RS.Open SQL, conn, 3 if RS.RecordCount <> 0 then Do While Not RS.EOF %> " rel="lightbox[roadtrip]"> <% RS.MoveNext LOOP end if rs.Close Set rs = Nothing Set Conex = Nothing %>
<%'--------------------------------------------------------------------------------------------- Set Conn= server.createobject("adodb.connection") DSNtest = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("dados/database.mdb") Conn.Open DSNtest Set RS= Server.CreateObject("ADODB.Recordset") SQL = "SELECT * FROM Galeria where categoria = '"& v_categ &"' order by categoria, c1" RS.Open SQL, conn, 3 if RS.RecordCount <> 0 then if RS.RecordCount > 1 then%>

Mais <%=v_categ%>


<% end if DO WHILE NOT RS.EOF %> <%if rs("id") <> v_id then%> ">
<%=rs("c1")%> - <%=rs("c2")%>
<%end if%> <% filtro = rs("categoria") RS.MoveNext LOOP end if rs.Close Set rs = Nothing Set Conex = Nothing %>