%@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 %>