Re: Inventory Adjustment

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29269
interpreted = N
texte = so I looked harder at your code and I think it was better before, you are returning the field explicitly named Inv, not a variable [Inv]. Sorry about that. But you are missing the ¬Found=xxx in the [lookup]. maybe that is all it needs. You originally had the [replace] inside a [lineitems]? Make sure that all the variable values you think are available to you within the [replace] actually are available. Do some simple tests with hard coded values then add variables back one at a time to see where it is breaking.-John Glenn Busbin wrote:> on 03/19/00 4:20 PM, John Butler at john@feeling-goods.com wrote: > > > Inv is missing a [ > > > > should be- > > &returnfield=[Inv] > > > > no? > > John, > I think so. But adding the [ somehow stops anything on the page below that > code from being processed. Even the html below that won't display after I > added the [. > > In any event, the database field Inv is still not being adjusted. > > I moved the code to the very bottom of the ThankYou.tpl page so that > everything gets processed and displayed before the Replace kicks in, but > there's still no inventory adjustment. > > I also tried moving the code > [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup > db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r > eplace] > > from the ThankYou.tpl page to the Invoice.tpl page and inserted it as > follows: > > > [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup > db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r > eplace] > > > I'd hoped that whenever the Submit Your Order button was hit, the Replace > context would be activated. Everything seems to work OK, but the INV field > is still not adjusted. > > Thanks for trying, though. > 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)
so I looked harder at your code and I think it was better before, you are returning the field explicitly named Inv, not a variable [Inv]. Sorry about that. But you are missing the ¬Found=xxx in the [lookup]. maybe that is all it needs. You originally had the [replace] inside a [lineitems]? Make sure that all the variable values you think are available to you within the [replace] actually are available. Do some simple tests with hard coded values then add variables back one at a time to see where it is breaking.-John Glenn Busbin wrote:> on 03/19/00 4:20 PM, John Butler at john@feeling-goods.com wrote: > > > Inv is missing a [ > > > > should be- > > &returnfield=[Inv] > > > > no? > > John, > I think so. But adding the [ somehow stops anything on the page below that > code from being processed. Even the html below that won't display after I > added the [. > > In any event, the database field Inv is still not being adjusted. > > I moved the code to the very bottom of the ThankYou.tpl page so that > everything gets processed and displayed before the Replace kicks in, but > there's still no inventory adjustment. > > I also tried moving the code > [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup > db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r > eplace] > > from the ThankYou.tpl page to the Invoice.tpl page and inserted it as > follows: > > > [Replace db=pol.db&eqSKUdatarq=[sku]]Inv=[math][lookup > db=pol.db&value=[sku]&lookinfield=sku&returnfield=[Inv]-[quantity][/math][/r > eplace] > > > I'd hoped that whenever the Submit Your Order button was hit, the Replace > context would be activated. Everything seems to work OK, but the INV field > is still not adjusted. > > Thanks for trying, though. > 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:

Country & Ship-to address & other fields ? (1997) Error: Too many nested [xxx] contexts (1997) Subtotal Not Calculated on Invoice.html (1998) OUTSIDE LINKS TO SHOW SHOPPING CART????????? (1998) read and write you own cookies with webcat (1997) replace problem (1999) Problems with [Applescript] (1997) Test (2003) [WriteFile] problems (1997) WebCat on Intel Core 2 macs anyone? (2007) [LOOKUP] (1997) Problems getting parameters passed into email. (1997) Search Engine questions ... (2002) Mozilla/4. and Browser Info.txt (1997) ShowNext for method=POST (1997) Can this be done? (1997) Summing fields (1997) Revisit: speed test (2002) Problems with [Applescript] (1997) suggestion (1997)