Inventory Management

This topic is locked

Inventory Management		5/22/2004 23:28:10
ASPRunnerPro General questions
P petski author I am writing a script http://www.websitedesignsforless.com/custi...entory_edit.asp user and password = admin I want user when the hit enter to be prompted with a blank text box for new sales quantity to input a value when user hits submit I want this value to add to current sold item total to add new sales. Example: Currenet Sold = 5 New Sales = 2 Database would now update Current Sold to = 7 This would be used to manage items currently available for sale. Thanks, Scott


	Sergey Kornilov admin 5/24/2004
	Scott, I guess you need to modify ...edit.asp file (lines 160-167) for this purpose. See my changes in bold: ... Â Â Â Â Â Â Â Â Â strValue=Request.Form(Request.Form("FieldName")(i)) Â Â Â Â Â Â Â end if Â Â Â Â Â end if Â Â end if end if if Request.Form("FieldName")(i)="Quantity" then Â Â strValue = strValue + Request.Form("Quantity Sold") end if strSQL = strSQL & strValue if i<>Request.Form("FieldName").Count then strSQL = strSQL & ", " ... I hope this helps.