STUDENT ALUMNI ASSOCIATION
The University of Alabama

 

Home
Activities
Community Service
Calendar
Officers
Members
Member Login
WANTED
Photos
National Alumni Association
FATE

 

     CONTACT SAA:
          saa@bama.ua.edu
          Alumni Hall
          P.O. Box 861928
          Tuscaloosa, AL 35486
          Phone: (205) 348-5963
          Fax: (205) 348-5958

 

COMING SOON!

Member Login

 

Username
Password

 
Privacy Policy - Site Map - Disclaimer
<%@LANGUAGE="JAVASCRIPT"%> <% // *** Validate request to log in to this site. var MM_LoginAction = Request.ServerVariables("URL"); if (Request.QueryString != "") MM_LoginAction += "?" + Server.HTMLEncode(Request.QueryString); var MM_valUsername = String(Request.Form("username")); if (MM_valUsername != "undefined") { var MM_fldUserAuthorization = ""; var MM_redirectLoginSuccess = "index.html"; var MM_redirectLoginFailed = "memberlogin.html"; var MM_loginSQL = "SELECT Username, Pword"; if (MM_fldUserAuthorization != "") MM_loginSQL += "," + MM_fldUserAuthorization; MM_loginSQL += " FROM employees WHERE Username = ? AND Pword = ?"; var MM_rsUser_cmd = Server.CreateObject ("ADODB.Command"); MM_rsUser_cmd.ActiveConnection = MM_conEmployees_STRING; MM_rsUser_cmd.CommandText = MM_loginSQL; MM_rsUser_cmd.Parameters.Append(MM_rsUser_cmd.CreateParameter("param1", 200, 1, 255, MM_valUsername)); // adVarChar MM_rsUser_cmd.Parameters.Append(MM_rsUser_cmd.CreateParameter("param2", 200, 1, 50, Request.Form("password"))); // adVarChar MM_rsUser_cmd.Prepared = true; var MM_rsUser = MM_rsUser_cmd.Execute(); if (!MM_rsUser.EOF || !MM_rsUser.BOF) { // username and password match - this is a valid user Session("MM_Username") = MM_valUsername; if (MM_fldUserAuthorization != "") { Session("MM_UserAuthorization") = String(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value); } else { Session("MM_UserAuthorization") = ""; } if (String(Request.QueryString("accessdenied")) != "undefined" && false) { MM_redirectLoginSuccess = Request.QueryString("accessdenied"); } MM_rsUser.Close(); Response.Redirect(MM_redirectLoginSuccess); } MM_rsUser.Close(); Response.Redirect(MM_redirectLoginFailed); } %> <% var rsEmployees_cmd = Server.CreateObject ("ADODB.Command"); rsEmployees_cmd.ActiveConnection = MM_conEmployees_STRING; rsEmployees_cmd.CommandText = "SELECT * FROM employees"; rsEmployees_cmd.Prepared = true; var rsEmployees = rsEmployees_cmd.Execute(); var rsEmployees_numRows = 0; %> <% // FileName="Connection_ado_conn_string.htm" // Type="ADO" // DesigntimeType="ADO" // HTTP="false" // Catalog="" // Schema="" var MM_conEmployees_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Inetpub\\wwwroot\\dreamweaver\\_database\\employees.mdb;" %> <% rsEmployees.Close(); %>