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:

Fun with Dates - finally resolved but.... (1997) WC2b12: Yes, Formulas.db is for real (1997) NT Woes (1997) Form based Redirect (2001) I'm tired of all this! (2000) Setting up shop (1997) E-mail formating question (1999) Appending current [date] to a database (1997) Webcat 2.0.1 date math bug -> Crash! (1997) [OT] QuickDNS (2007) Server IP address (2004) Tab Charactor (1997) creating a ShipCosts database (1997) Is the list server working? (1998) method of payment (1997) 2.0Beta Command Ref (can't find this instruction) (1997) default value from Lookup (was Grant, please help me) (1997) 4.x in production update (2000) Basics of tcpconnect (2006) WebCat on 10.0.4 - iTools 6.0 (2001)