Re: Inventory Adjustment SOLUTION

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29357
interpreted = N
texte = This is the solution to my problem of deducting the items ordered from the number of those items available in the database. See the comment tags () in the code for a bit more info.The code below is from the ThankYou.tpl page. [orderfile cart=[cart]][SetHeader cart=[cart]]payMethod=[showif [useAC]=T]AC[/showif][hideif [useAC]=T]CC[/hideif]&[formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/SetHeader]
Date: [date %B %m, %Y]Time: [time %I:%M:%S]Order #: [cart]
[lineItems] [Replace db=mydatabase.db&eqskudatarq=[sku]]Inv=[math][lookup db=mydatabase.db&value=[sku]&lookinfield=sku&returnfield=Inv]-[quantity][/ma th][/replace][/lineItems]
Item #Product #NameQtyPriceExtension
[lineindex][sku][textA][quantity]$[price]$[format .2f][math][quantity]*[price][/math][/format]
Subtotal  $[subTotal]
[ShipTostate] Tax Rate: [taxRate] % Tax  $[taxTotal]
[shipVia] Shipping & Handling  $[shipCost]
Grand Total  $[grandTotal]

[include file=ThankYouInfo.inc]

[/orderfile][purchase cart=[cart]][/showif]------------------------------------------------------------- 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)
This is the solution to my problem of deducting the items ordered from the number of those items available in the database. See the comment tags () in the code for a bit more info.The code below is from the ThankYou.tpl page. [orderfile cart=[cart]][SetHeader cart=[cart]]payMethod=[showif [useAC]=T]AC[/showif][hideif [useAC]=T]CC[/hideif]&[formvariables name=__&exact=F][getchars start=3][name][/getchars]=[url][value][/url]&[/formvariables][/SetHeader]
Date: [date %B %m, %Y]Time: [time %I:%M:%S]Order #: [cart]
[lineitems] [Replace db=mydatabase.db&eqskudatarq=[sku]]Inv=[math][lookup db=mydatabase.db&value=[sku]&lookinfield=sku&returnfield=Inv]-[quantity][/ma th][/replace][/lineItems]
Item #Product #NameQtyPriceExtension
[lineindex][sku][textA][quantity]$[price]$[format .2f][math][quantity]*[price][/math][/format]
Subtotal  $[subTotal]
[ShipTostate] Tax Rate: [taxRate] % Tax  $[taxTotal]
[shipVia] Shipping & Handling  $[shipCost]
Grand Total  $[grandTotal]

[include file=ThankYouInfo.inc]

[/orderfile][purchase cart=[cart]][/showif]------------------------------------------------------------- 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 Glenn Busbin

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:

Secured Order Forms (1998) Text data with spaces in them... (1997) MAC versions of WebCatalog 2.1 and WebMerchant 2.1 (1998) Template Security error (1997) Server crashes and triggers . . . are they linked? (2001) emailer error -108 (1997) autosensing lanague selection (1997) WebCatalog2 Feature Feedback (1996) Emailer (WebCat2) (1997) [input] .... [/input] usage (2005) Something wrong with this list? (2006) Access Denied! But why? (1997) [WebDNA] random blank results? how come? (2014) This list needs a digest: rant, rave... (1997) Round up prices (2000) newbie question about zip code search (2003) Nested tags count question (1997) stumped (2001) X etc.... (1999) letterrip and webcats emailer (1998)