Formulas and Prices
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34721
interpreted = N
texte = For the life of me, I can't find a solution to the problem of having multiple prices for one item based on the quantity ordered.My latest attempt used the example in the Formulas section of the HTML docs. The example says:>[math][showif [username]=GRANT]0.0*[/showif][lookup >db=catalog.txt&lookInField=sku&value=[sku]&returnField=price][/math] > >This example would set the price to $0 if the user was logged in as >GRANT, otherwise the price would be unchanged.Simple enough. As a test, I changed the Formulas.db to:Name Formula price [math][showif [quantity]>2]0.9*[/showif][lookup db=mydatabase.db&lookInField=sku&value=[sku]&returnField=price][/math]This doen't work no matter what the [quantity] field says (Yes, the correct value is passed to the [quantity] field). It shows the exact same price as does: Name Formula price [lookup db=POL.db&lookInField=sku&value=[sku]&returnField=price]andName Formula price [price].I appreciate the security built into WC to protect the price field, but sure wish there was a convenient way to have more than one price per item. Given the number of posts in the archives about this, so do some others.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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Formulas and Prices (Glenn Busbin 2000)
|
For the life of me, I can't find a solution to the problem of having multiple prices for one item based on the quantity ordered.My latest attempt used the example in the Formulas section of the HTML docs. The example says:>[math][showif [username]=GRANT]0.0*[/showif][lookup >db=catalog.txt&lookInField=sku&value=[sku]&returnField=price][/math] > >This example would set the price to $0 if the user was logged in as >GRANT, otherwise the price would be unchanged.Simple enough. As a test, I changed the formulas.db to:Name Formula price [math][showif [quantity]>2]0.9*[/showif][lookup db=mydatabase.db&lookInField=sku&value=[sku]&returnField=price][/math]This doen't work no matter what the [quantity] field says (Yes, the correct value is passed to the [quantity] field). It shows the exact same price as does: Name Formula price [lookup db=POL.db&lookInField=sku&value=[sku]&returnField=price]andName Formula price [price].I appreciate the security built into WC to protect the price field, but sure wish there was a convenient way to have more than one price per item. Given the number of posts in the archives about this, so do some others.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 Web Archive of this list is at: http://search.smithmicro.com/
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:
[removehtml]? (2000)
[WebDNA] PayPal Integration (2017)
template cache problem (1998)
upgrade? (1997)
faulure to encrypt (or maybe decrypt) (1999)
Language definitions and convertion (2000)
Sku numbers (1997)
email preferences on NT (1997)
Site Search Concepts (2003)
How true is this? (1999)
OT - Public Upload Security (2002)
Hello??? (1997)
Same DB Same Time (2004)
HTML Editors (1997)
Reversed words (1997)
I need a Smart-quote workaround (1999)
pop up menu's (1998)
Keeping the cart alive through multiple add commands (2000)
Log-in Scheme (2003)
[WebDNA] Language References (2011)