<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% Dim MM_editAction MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit Dim MM_abortEdit MM_abortEdit = false %> <% ' *** Delete Record: construct a sql delete statement and execute it If (CStr(Request("MM_delete")) = "modItem" And CStr(Request("MM_recordId")) <> "") Then If (Not MM_abortEdit) Then ' execute the delete Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_conAcme_STRING MM_editCmd.CommandText = "DELETE FROM acmedemo.Inventory WHERE itemID = ?" MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 5, 1, -1, Request.Form("MM_recordId")) ' adDouble MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "/acme/admin/inventory.asp" If (Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If Response.Redirect(MM_editRedirectUrl) End If End If %> <% Dim rsCategory Dim rsCategory_cmd Dim rsCategory_numRows Set rsCategory_cmd = Server.CreateObject ("ADODB.Command") rsCategory_cmd.ActiveConnection = MM_conAcme_STRING rsCategory_cmd.CommandText = "SELECT * FROM acmedemo.categories ORDER BY category ASC" rsCategory_cmd.Prepared = true Set rsCategory = rsCategory_cmd.Execute rsCategory_numRows = 0 %> <% Dim rsModitem__MMColParam rsModitem__MMColParam = "1" If (Request.QueryString("itemID") <> "") Then rsModitem__MMColParam = Request.QueryString("itemID") End If %> <% Dim rsModitem Dim rsModitem_cmd Dim rsModitem_numRows Set rsModitem_cmd = Server.CreateObject ("ADODB.Command") rsModitem_cmd.ActiveConnection = MM_conAcme_STRING rsModitem_cmd.CommandText = "SELECT * FROM acmedemo.Inventory WHERE itemID = ?" rsModitem_cmd.Prepared = true rsModitem_cmd.Parameters.Append rsModitem_cmd.CreateParameter("param1", 5, 1, -1, rsModitem__MMColParam) ' adDouble Set rsModitem = rsModitem_cmd.Execute rsModitem_numRows = 0 %> Acme Item Details

<%=(rsModitem.Fields.Item("itemName").Value)%> Details

Details about <%=(rsModitem.Fields.Item("itemName").Value)%>.
	Item Name	Description	Category	# in Stock	Item Size
" onfocus="newwindow(''); return false;">" />	<%=(rsModitem.Fields.Item("itemName").Value)%>	<%=(rsModitem.Fields.Item("itemDescription").Value)%>	<%=(rsModitem.Fields.Item("category").Value)%>	<%=(rsModitem.Fields.Item("stock").Value)%>	<%=(rsModitem.Fields.Item("itemSize").Value)%>	">Add <%=(rsModitem.Fields.Item("itemName").Value)%> to cart

Legal Info
All images used are believed to be covered by 'Fair Use'. If you believe this to be false please contact the owner and they will be removed.

<% rsitemDetails.Close() Set rsitemDetails = Nothing %>