%@ CodePage = 28591 LCID = 1033 %> <% ewCurSec = 0 ' Initialise ' User levels Const ewAllowAdd = 1 Const ewAllowDelete = 2 Const ewAllowEdit = 4 Const ewAllowView = 8 Const ewAllowList = 8 Const ewAllowReport = 8 Const ewAllowSearch = 8 Const ewAllowAdmin = 16 %> <% If Session("nationalproduct_status") <> "login" Then Response.Redirect "login.asp" End If %> <% ' Initialize common variables x_customerID = Null x_username = Null x_password = Null x_contactname = Null x_company = Null x_address = Null x_city = Null x_state = Null x_zip = Null x_phone = Null x_ship_contactname = Null x_ship_company = Null x_ship_address = Null x_ship_city = Null x_ship_state = Null x_ship_zip = Null x_ship_phone = Null %> <% Response.Buffer = True sKey = Request.Querystring("key") If sKey = "" Or IsNull(sKey) Then Response.Redirect"login.asp" sAction = "I" ' Open connection to the database Set conn = Server.CreateObject("ADODB.Connection") conn.Open xDb_Conn_Str Select Case sAction Case "I": ' Get a record to display If Not LoadData(sKey) Then ' Load Record based on key Session("ewmsg") = "No Record Found for Key = " & sKey conn.Close ' Close Connection Set conn = Nothing Response.Clear Response.Redirect "customerlist.asp" End If End Select %>
| ||||||||||||||||||||||||||||||||||||||||||||||||