% dim myTMT, strMsg 'set myTMT = server.createobject("ewatmt.atmt") 'myTMT.ConnectDB "209.171.252.228,7588","atmt30demo", "atmt30demo", "atmt30demopwd" set myTMT = new ATMT dim rs 'set rs = Server.CreateObject("ADODB.Recordset") strMsg = "" set rs = myTMT.ListCategory if request.form("remove") = "Remove" then 'myTMT.SubscribersEmail = request.form("email") retval = myTMT.RemoveUser (request("email").item) select case retval case 0 strMsg = "Email was removed successfully." case 1 strMsg = "Your email was not on this list." case 17 strMsg = "SQL Err. Please try later." end select end if if request.querystring("action") = "register" then FirstName = request.form("fname") LastName = request.form("lname") CompanyName = request.form("company") Address1 = request.form("address1") Address2 = request.form("address2") CityName = request.form("city") StateName = request.form("state") PostCode = request.form("postal") CountryName = request.form("country") PhoneNumber = request.form("phone") FaxNumber = request.form("fax") SubscribersEmail = request.form("email") SubscribersNote = request.form("comments") SelectedCategoryList = request.form("products") retval = myTMT.AddUpdateUser (firstname,lastname,companyname,address1,address2,cityname,statename,postcode,countryname,phonenumber,faxnumber,subscribersemail,subscribersnote) select case retval case 0 strMsg = "Your profile was successfully added." case 1 strMsg = "Your profile was successfully updated." case 18,19 strMsg = "SQL Server Err. Please try it later." end select end if %>
| <%=strMsg %> |