Re: Inventory Adjustment
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29261
interpreted = N
texte = Inv is missing a [should be-&returnfield=[Inv]no?-JohnGlenn Busbin wrote:> I'm trying to deduct quantities ordered from inventory and do it as the> order is submitted.>> I found the following code in the archives, but can't get it to make any> deductions from inventory.>> [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup> db=pol.db&value=[sku]&lookinfield=SKU&returnfield=Inv]-[quantity][/math][/re> place]>> I put this code on the ThankYou.tpl page which is accessed only after the> order has been submitted.>> My database is named pol.db> There are fields in it named SKU and Inv.>> Does anyone see why this code won't deduct ordered items from inventory?>> Thanks,> Glenn>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Inv is missing a [should be-&returnfield=[Inv]no?-JohnGlenn Busbin wrote:> I'm trying to deduct quantities ordered from inventory and do it as the> order is submitted.>> I found the following code in the archives, but can't get it to make any> deductions from inventory.>> [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup> db=pol.db&value=[sku]&lookinfield=SKU&returnfield=Inv]-[quantity][/math][/re> place]>> I put this code on the ThankYou.tpl page which is accessed only after the> order has been submitted.>> My database is named pol.db> There are fields in it named SKU and Inv.>> Does anyone see why this code won't deduct ordered items from inventory?>> Thanks,> Glenn>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
John Butler
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WC2b12: Yes, Formulas.db is for real (1997)
RE: pop up building with summarize (1998)
WebCat2 Append problem (B14Macacgi) (1997)
Webcat Manual and TeaRoom Examples Uses Different Examples. (1997)
Limit picture size on upload (2005)
E-mailer error codes (1997)
Generating Report Totals (1997)
Security for malls with different webmasters (1998)
[BULK] [WebDNA] [BULK] Mac OS X LION has no FastCGI (2011)
ImageMap (1997)
[WebDNA] making all fields on a form mandatory (2013)
error in log but only rarely (2005)
RE: storefront (1998)
Setting up the server (1997)
WebMerchant 1.6 and SHTML (1997)
emailer (1997)
New Command prefs ... (1997)
Multiple prices (1997)
PCS Frames (1997)
Visitor info (2000)