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:

    
  1. Re: Inventory Adjustment SOLUTION (John Butler 2000)
  2. Re: Inventory Adjustment SOLUTION (Glenn Busbin 2000)
  3. Re: Inventory Adjustment (Glenn Busbin 2000)
  4. Re: Inventory Adjustment (John Butler 2000)
  5. Re: Inventory Adjustment (Kenneth Grome 2000)
  6. Re: Inventory Adjustment (Glenn Busbin 2000)
  7. Re: Inventory Adjustment (John Butler 2000)
  8. Re: Inventory Adjustment (Glenn Busbin 2000)
  9. Re: Inventory Adjustment (John Butler 2000)
  10. Inventory Adjustment (Glenn Busbin 2000)
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)