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:
Heads up, cookies *may* be outlawed in Europe (2001)
little help (2001)
Passing Variable (was How to add product size) (1997)
[/application] error? (1997)
Search (1997)
Help name our technology! (1997)
cookies and case (2006)
[WebDNA] [OT] economical reliable SSL certs? (2009)
Uploading Files and Descriptions W* (2000)
Re2: Calculating multiple shipping... (1997)
Sendmail truncation in Eudora Clients (1998)
WebMerchant 3.0? (1998)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
2.0 Info (1997)
RE:It just Does't add up!!! (1997)
HTTP "host" header (2003)
WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997)
Range Comparisons (2000)
Help name our technology! (1997)
Sku numbers (1997)