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:

Search bug. Help (2002) Getting Rid of Multiple Returns (2001) [ModDate] & [ModTime] ? (1997) Is everybody getting all the posts? (2002) Attn: Bug in GeneralStore example b15 (1997) Opinion: [input] should be called [output] ... (1997) WebCatalog Beta Documentation (1997) RE: automatic reload of frameset (1997) Alternating colors (1997) Orderfile context problem (1998) RE: [WebDNA] Libmysql.dll error (2009) [WebDNA] group searching not working as expected. (2010) Setting up WebCatalog with Retail Pro data (1996) Nesting format tags (1997) big database file (2000) Database Strategy - more... (1998) Apache on windows and WebDNA (2004) a small clarification (2002) New public beta available (1997) File Upload (1997)