Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Salve salve rapaziada...
Segue mais uma dúvida que tenho:
Quero apagar múltiplos registros (usuários) do banco de dados, porém quero que quando carregue a página desabilite o check box do usuário que está conectado.
Uso Dreamweaver / Acess!!!
Deu pra entender??
Segue código:
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<%
// *** Logout the current user.
MM_Logout = String(Request.ServerVariables("URL")) + "?MM_Logoutnow=1";
if (String(Request("MM_Logoutnow"))=="1") {
Session.Contents.Remove("MM_Username");
Session.Contents.Remove("MM_UserAuthorization");
var MM_logoutRedirectPage = "../index.asp";
// redirect with URL parameters (remove the "MM_Logoutnow" query param).
if (MM_logoutRedirectPage == "") MM_logoutRedirectPage = String(Request.ServerVariables("URL"));
if (String(MM_logoutRedirectPage).indexOf("?") == -1 && Request.QueryString != "") {
var MM_newQS = "?";
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
if (String(items.item()) != "MM_Logoutnow") {
if (MM_newQS.length > 1) MM_newQS += "&";
MM_newQS += items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}
if (MM_newQS.length > 1) MM_logoutRedirectPage += MM_newQS;
}
Response.Redirect(MM_logoutRedirectPage);
}var MM_authorizedUsers="proprietario";
var MM_authFailedURL="../index.asp";
var MM_grantAccess=false; MM_grantAccess = true;
}
}
if (!MM_grantAccess) {
var MM_qsChar = "?";
if (MM_authFailedURL.indexOf("?") >= 0) MM_qsChar = "&";
var MM_referrer = Request.ServerVariables("URL");
if (String(Request.QueryString()).length > 0) MM_referrer = MM_referrer + "?" + String(Request.QueryString());
MM_authFailedURL = MM_authFailedURL + MM_qsChar + "accessdenied=" + Server.URLEncode(MM_referrer);
Response.Redirect(MM_authFailedURL);
}// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
MM_editAction += "?" + Server.HTMLEncode(Request.QueryString);
}// boolean to abort record edit
var MM_abortEdit = false;
%>
<%
// *** Delete Record: construct a sql delete statement and execute it
if (String(Request("MM_delete")) == "a_usuario" &&
String(Request("MM_recordId")) != "undefined") {
if (!MM_abortEdit) {
// execute the delete
var MM_editCmd = Server.CreateObject ("ADODB.Command");
MM_editCmd.ActiveConnection = MM_con_fvsj_STRING;
MM_editCmd.CommandText = "DELETE FROM adm WHERE cod = ?"
MM_editCmd.Prepared = true;
MM_editCmd.Parameters.Append(MM_editCmd.CreateParameter("param1", 5, 1, -1, Request.Form("MM_recordId"))); // adDouble
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();
// append the query string to the redirect URL
var MM_editRedirectUrl = "../ent.asp";
if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1) ? "?" : "&") + Request.QueryString;
}
Response.Redirect(MM_editRedirectUrl)
}
}var a_usuario_cmd = Server.CreateObject ("ADODB.Command");
a_usuario_cmd.ActiveConnection = MM_con_fvsj_STRING;
a_usuario_cmd.CommandText = "SELECT * FROM adm";
a_usuario_cmd.Prepared = true;
var a_usuario = a_usuario_cmd.Execute();
var a_usuario_numRows = 0;var Repeat1__numRows = 10;
var Repeat1__index = 0;
a_usuario_numRows += Repeat1__numRows;<html>
<head>
<title>xxxx</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<script type="text/ecmascript"></script>
<table border="0" width="100%" cellspacing="0" cellpadding="0" height="5">
<tr>
<td width="100%" height="29"><font size="5" face="Impact" color="#333333">Sistema Administrativo -
http-~~-//www.velassaojoao.com.br</font></td>
</tr>
<tr>
<td width="100%" height="21">
<p align="right"><font color="#C0C0C0">Bem
Vindo
<%Response.Write(Session("MM_Username"))%>
! </font></td>
</tr>
<tr>
<td width="100%" height="37" background="../../imagens/f_tab_adm.jpg" valign="middle">
<p align="right"><font color="#333333"><img border="0" src="../../imagens/b_adm.jpg">
<a href="../ent.asp">Inicial</a> <img border="0" src="../../imagens/b_adm.jpg">
<a href="e_usuario.asp">Editar usuário</a> <img src="../../imagens/b_adm.jpg" width="8" height="8"> <a href="<%= MM_Logout %>">Sair</a> </font></p> </td>
</tr>
</table>
<form ACTION="<%=MM_editAction%>" method="POST" name="a_usuario" id="a_usuario">
<br>
<table width="304" border="1" align="center" cellpadding="2" cellspacing="0" bordercolor="#333333" height="116">
<tr>
<td colspan="2" height="19"><div align="right" class="style1">Apagar Usuário </div></td>
</tr>
<tr bgcolor="#333333">
<td colspan="2" height="12"> </td>
</tr>
<% while ((Repeat1__numRows-- != 0) && (!a_usuario.EOF)) { %>
<tr>
<td width="30"><div align="center">
<input name="usuario" type="checkbox" id="usuario">
</div></td>
<td width="260" height="23"><input name="nome" type="text" id="nome" style="background-color: #000000; font-size: 10px; color: #FFCC00; font-family: Verdana; border: 1 solid #FFCC00" value="<%=(a_usuario.Fields.Item("login").Value)%>" size="40"></td>
</tr>
<%
Repeat1__index++;
a_usuario.MoveNext();
}<tr valign="middle">
<td height="60" colspan="2"><div align="right">
<input type="image" name="imageField" id="imageField" src="../../imagens/b_av2.png">
</div></td>
</tr>
</table>
<input type="hidden" name="MM_delete" value="a_usuario">
<input type="hidden" name="MM_recordId" value="<%= a_usuario.Fields.Item("cod").Value %>">
</form>
</body>
</html>Carregando comentários...