%@ LANGUAGE="VBSCRIPT" %>
<%
'***********************************************************************
' System : ASPBanner
' Author : Christopher Williams of CJWSoft www.CJWSoft.com
'
' COPYRIGHT NOTICE
'
' See attached Software License Agreement
'
' (c) Copyright 2000 - 2001 by CJWSoft. All rights reserved
'***********************************************************************
%>
<% CHECKFOR = "Admin" %>
<%
Action = Request("Action")
User_ID = Request("User_ID")
%>
<% =App_Name %>
>
<%
ErrorMessage = Request("ErrorMessage")
If ErrorMessage <> "" Then
%>
<%
End If
If Action <> "New_User" Then
Set ConnPasswords = Server.CreateObject("ADODB.Connection")
Set CmdEditUser = Server.CreateObject("ADODB.Recordset")
ConnPasswords.Open BannerConnectionString
SQL = "SELECT Banner_Users.* FROM Banner_Users WHERE (User_ID = " & User_ID & ")"
CmdEditUser.Open SQL, ConnPasswords
Expiration_Date =CmdEditUser("Expiration_Date")
If IsEmpty(Expiration_Date) Or IsNull(Expiration_Date) Or Expiration_Date ="" Then
Expiration_Date = ""
Else
Expiration_Date = month(Expiration_Date) & "/" & day(Expiration_Date) & "/" & year(Expiration_Date)
End If
UserExpired = "No"
If Expiration_Date <> "" Then
If CDATE(Expiration_Date) <= DATE Then
UserExpired = "Yes"
End If
End If
End If
If ErrorMessage <> "" Then
First_Name = Request("First_Name")
Last_Name = Request("Last_Name")
Company_Name = Request("Company_Name")
Address = Request("Address")
City = Request("City")
State_Province = Request("State_Province")
Zipcode_Postal_Code = Request("Zipcode_Postal_Code")
Email = Request("Email")
Phone = Request("Phone")
Custom1 = Request("Custom1")
Custom2 = Request("Custom2")
Custom3 = Request("Custom3")
Custom4 = Request("Custom4")
Custom5 = Request("Custom5")
Custom6 = Request("Custom6")
Username = Request("Username")
Password = Request("Password")
Notes = Request("Notes")
Else
First_Name = CmdEditUser("First_Name")
Last_Name = CmdEditUser("Last_Name")
Company_Name = CmdEditUser("Company_Name")
Address = CmdEditUser("Address")
City = CmdEditUser("City")
State_Province = CmdEditUser("State_Province")
Zipcode_Postal_Code = CmdEditUser("Zipcode_Postal_Code")
Email = CmdEditUser("Email")
Phone = CmdEditUser("Phone")
Custom1 = CmdEditUser("Custom1")
Custom2 = CmdEditUser("Custom2")
Custom3 = CmdEditUser("Custom3")
Custom4 = CmdEditUser("Custom4")
Custom5 = CmdEditUser("Custom5")
Custom6 = CmdEditUser("Custom6")
Username = CmdEditUser("Username")
Password = CmdEditUser("Password")
Notes = CmdEditUser("Notes")
End If
%>
<%
If Action = "New_User" Then
CmdEditUser.Close
Set CmdEditUser = Nothing
ConnPasswords.Close
Set ConnPasswords = Nothing
End If
%>