%@LANGUAGE="JAVASCRIPT"%> <% var rsUpdate__MMColParam = "1"; if(String(Session("MM_Username")) != "undefined") { rsUpdate__MMColParam = String(Session("MM_Username")); } %> <% var rsUpdate = Server.CreateObject("ADODB.Recordset"); rsUpdate.ActiveConnection = MM_HW_Con_STRING; rsUpdate.Source = "SELECT COMPANY, VENDOR, ADDR, CITYZIP, ZIP, SHIPADD, SHIPCITY, SHIPSTATE, SHIPZIP, SHIPNAME FROM AVENDOR WHERE VENDOR = '"+ rsUpdate__MMColParam.replace(/'/g, "''") + "'"; rsUpdate.CursorType = 0; rsUpdate.CursorLocation = 2; rsUpdate.LockType = 3; rsUpdate.Open(); var rsUpdate_numRows = 0; %> <% var rsFindPass__MMColParam = "0"; if(String(Request.Form("Email")) != "undefined") { rsFindPass__MMColParam = String(Request.Form("Email")); } %> <% var rsFindPass = Server.CreateObject("ADODB.Recordset"); rsFindPass.ActiveConnection = MM_HW_Con_STRING; rsFindPass.Source = "SELECT * FROM AVENDOR WHERE EMAIL = '"+ rsFindPass__MMColParam.replace(/'/g, "''") + "'"; rsFindPass.CursorType = 0; rsFindPass.CursorLocation = 2; rsFindPass.LockType = 1; rsFindPass.Open(); var rsFindPass_numRows = 0; %> <% // *** Validate request to log in to this site. var MM_LoginAction = Request.ServerVariables("URL"); if (Request.QueryString!="") MM_LoginAction += "?" + Request.QueryString; var MM_valUsername=String(Request.Form("UserID")); if (MM_valUsername != "undefined") { var MM_fldUserAuthorization=""; var MM_redirectLoginSuccess="/doc/HW_MemberResUpdate.asp"; var MM_redirectLoginFailed="/doc/HW_loginfailed.asp"; var MM_flag="ADODB.Recordset"; var MM_rsUser = Server.CreateObject(MM_flag); MM_rsUser.ActiveConnection = MM_HW_Con_STRING; MM_rsUser.Source = "SELECT VENDOR, PASSWORD"; if (MM_fldUserAuthorization != "") MM_rsUser.Source += "," + MM_fldUserAuthorization; MM_rsUser.Source += " FROM AVENDOR WHERE VENDOR='" + MM_valUsername + "' AND PASSWORD='" + String(Request.Form("Password")) + "'"; MM_rsUser.CursorType = 0; MM_rsUser.CursorLocation = 2; MM_rsUser.LockType = 3; MM_rsUser.Open(); 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); } %>
|
|
|||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
|
Contact
Us | Customer
Service | Customer Policy
| |
|||||||||||||||||||||||||||||||||||||
<% rsUpdate.Close(); %> <% rsFindPass.Close(); %>