SELECT * FROM Tester
MM_valUsername=Evaluate("FORM." & "UserName");
MM_fldUserAuthorization="";
MM_redirectLoginSuccess="AcuOrthoTest.cfm";
MM_redirectLoginFailed="LoginFail.cfm";
MM_dataSource=MM_Iama_DSN;
MM_queryFieldList = "UserName,Password,TesterID";
if (MM_fldUserAuthorization IS NOT "") MM_queryFieldList=MM_queryFieldList & "," & MM_fldUserAuthorization;
SELECT #MM_queryFieldList# FROM Tester WHERE UserName='#MM_valUsername#' AND Password='#Evaluate("FORM."
& "Password")#'
// username and password match - this is a valid user
Session.MM_Username = MM_valUsername;
if (MM_fldUserAuthorization IS NOT "") {
Session.MM_UserAuthorization = MM_rsUser[MM_fldUserAuthorization][1];
} else {
Session.MM_UserAuthorization = "";
}
if (IsDefined("accessdenied") AND false) {
MM_redirectLoginSuccess = Evaluate("accessdenied");
}
MM_LoginAction = CGI.SCRIPT_NAME;
if (CGI.QUERY_STRING NEQ "") MM_LoginAction = MM_LoginAction & "?" & CGI.QUERY_STRING;
IAMA
