<%if request.form("uniqueid") = "" then%> Parts Administration <%if Session("level") <> 4 and Request.querystring("CustID") <> CustID2 then response.redirect ("http://www.laundry-carts.com") end if%> <% If Session("Categ") = "" Then Session("Categ") = Request.QueryString("Categ") End If Set LaunDB = LaunConn.Execute("SELECT * FROM " & Session("Categ") & " WHERE partnumber = '" & request.querystring("partnumber") & "';") %> Modify Part <%=request.querystring("partnumber")%> <% LaunDB.Close Set LaunDB = Nothing else %> <% uniquepartid = Replace(request.form("uniqueid"), "'", "''") partnumber = Replace(request.form("partnumber"), "'", "''") partdescription = trim(Replace(request.form("partdescription"), "'", "''")) longdescription1 = trim(Replace(request.form("longdescription1"), "'", "''")) longdescription2 = trim(Replace(request.form("longdescription2"), "'", "''")) price = Replace(request.form("price"), "'", "''") weight = Replace(request.form("weight"), "'", "''") sql = "UPDATE " & Request.Form("Category") & " SET partnumber = '" & partnumber & "', partdescription = '" & partdescription & "', longdescription1 = '" & longdescription1 & "', longdescription2 = '" & longdescription2 & "', " sql = sql & "price = '" & price & "', weight = " & cint(weight) sql = sql & " WHERE uniquepartid = " & cint(uniquepartid) & ";" launconn.execute(sql) LaunConn.Close Set LaunConn = Nothing %> <%end if%> SKU Number: "> "> "> Short Description: " size="35" > Long Description 1: " size="35" > Long Description 2: " size="35" > Price: " size="35" > Weight: " size="30" > Changed submitted! for your part, click here to return to the parts administration page.

Return to Menu