This topic is locked

Inventory Management

5/22/2004 11:28:10 PM
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.