Variable prices and Formulas.db

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11854
interpreted = N
texte = I am having difficulty with the price field and the formulas.db.I have set the record in formulas.db tPrice [math][showif [quantity]>9.9].70*[/showif][lookup db=/homepage/cat.txt&lookInField=sku&Value=[sku]&returnFi3eld=price] [/math]Both the formulas.db and cat.txt are in the same directory. When I add an item to the cart located in /Homepage/Carts It price is set to zero.Is the formula wrong? What should the Add command look like? How is the price associated with the Line Item?Thanks Austin Associated Messages, from the most recent to the oldest:

    
  1. Re: Variable prices and Formulas.db (Grant Hulbert 1997)
  2. Variable prices and Formulas.db (Austin H. Spiegelman 1997)
I am having difficulty with the price field and the formulas.db.I have set the record in formulas.db tPrice [math][showif [quantity]>9.9].70*[/showif][lookup db=/homepage/cat.txt&lookInField=sku&Value=[sku]&returnFi3eld=price] [/math]Both the formulas.db and cat.txt are in the same directory. When I add an item to the cart located in /Homepage/Carts It price is set to zero.Is the formula wrong? What should the Add command look like? How is the price associated with the Line Item?Thanks Austin Austin H. Spiegelman

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:

Anyone running WebMerchant 4.0? (2000) PCS Frames (1997) RE: 2nd WebCatalog2 Feature Request (1996) Emailer setup (1997) Universal root for WC errors? (1997) Client-side Image Maps and WebCat (what's a database-drivensite)? (1998) bypassing typo's (1998) why is authenticate screwing with me today (2002) More on the email templates (1997) Keep away (1997) WebMerchant 1.6 and SHTML (1997) b12 cannot limit records returned and more. (1997) Emailed problem (2000) WebCat b15 Mac plug-in (1997) Stumped (1999) Security (1998) [subtotal] and others (1997) make updates in a temporary database (2004) WebDNA version? (2007) restart needed???? (1997)