Re: Price and Formula.db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45567
interpreted = N
texte = Glenn, glad you got it to work.I see you used TextD... This is still not really confirming my question.Can SOMEONE chime in here?,...Can a variable be passed into a formulas.db other than theorderfile/lineitems and internal webcatvariables?thanks,DonovanGlenn Busbin wrote:> [snip]> This works:> Name Formula> Price [Math][lookup db=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+([lookup db=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]*[lookup db=Woods.db&lookinfield=Woods&value=[URL][TextD][/URL]&returnfield=ExtraCost])[/Math][snip]-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------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:
Glenn, glad you got it to work.I see you used TextD... This is still not really confirming my question.Can SOMEONE chime in here?,...Can a variable be passed into a formulas.db other than theorderfile/lineitems and internal webcatvariables?thanks,DonovanGlenn Busbin wrote:> [snip]> This works:> Name Formula> Price [math][lookup db=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+([lookup db=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]*[lookup db=Woods.db&lookinfield=Woods&value=[url][TextD][/URL]&returnfield=ExtraCost])[/Math][snip]-- ------------------------------------------------------------------------ ------------------------------------------------------------------------<><> Donovan Brooke <><>->ï ------------------------------------------------------------------------ -------------------------------------------------------------------------------------------------------------------------------------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/
Donovan
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:
creating an email message (1998)
WebCatalog Upgrade Pricing? (1997)
using showpage and showcart commands (1996)
Emailer errors (1997)
send mail problem? (1997)
[TaxTotal] (1998)
MATH TIME (1997)
Re:Signal Raised (1997)
weight based shipping cost questions (1997)
[OT] SSL (2003)
[WriteFile] problems (1997)
One more try: WebCat for Dummies p2.2 (2000)
re:check boxes (1997)
Just Testing (1997)
Help Please WebDNA 6 Secure Forms Problem (2004)
WebTen? (1997)
ODBC Performance? (2001)
Help Please WebDNA 6 Secure Forms Problem (2004)
Running 2 two WebCatalog.acgi's (1996)
Re:Email (1998)