% sql = "SELECT * FROM categorias ORDER by nome" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, MeuDB, 3, 3 varIdAutor = CInt(Session("idUsu")) sqlNot = "SELECT * FROM notas WHERE idAutor = " & varIdAutor &" ORDER by dt DESC" Set rsNot = Server.CreateObject("ADODB.Recordset") rsNot.Open sqlNot, MeuDB, 3, 3 sqlArt = "SELECT * FROM artigos ORDER by dt DESC" Set rsArt = Server.CreateObject("ADODB.Recordset") rsArt.Open sqlArt, MeuDB, 3, 3 varId = request("id") if varId <> EMPTY then sqlEdita = "SELECT * FROM notas WHERE id = " & varId Set rsEdita = Server.CreateObject("ADODB.Recordset") rsEdita.Open sqlEdita, MeuDB, 3, 3 strAcao = "edita" else strAcao = "inclui" end if %>
<% if strAcao = "inclui" then %>