% if request("change") <> "" then if request("change") = "image1" then SQLUpdate = "UPDATE Forces_Items SET Image1 = '', Thumb1 = '' WHERE ItemID= '"&request("cid")&"' " MyConn.execute(SQLUpdate) response.redirect "item-update.asp?id="&request("cid") end if if request("change") = "image2" then SQLUpdate = "UPDATE Forces_Items SET Image2 = '', Thumb2 = '' WHERE ItemID= '"&request("cid")&"' " MyConn.execute(SQLUpdate) response.redirect "item-update.asp?id="&request("cid") end if if request("change") = "image3" then SQLUpdate = "UPDATE Forces_Items SET Image3 = '', Thumb3 = '' WHERE ItemID= '"&request("cid")&"' " MyConn.execute(SQLUpdate) response.redirect "item-update.asp?id="&request("cid") end if end if %> <% Set UploadProgress = Server.CreateObject("Persits.UploadProgress") PID = "PID=" & UploadProgress.CreateProgressID() barref = "framebar.asp?to=10&" & PID %>
| Update your item |
<%GetItem = "SELECT * FROM Forces_Items WHERE ItemID = '"&killchars(request("id"))&"' " SET RSItem = MyConn.execute(GetItem) Do While NOT RSItem.EOF%> <%RSItem.Movenext Loop%> |