Re: Price and Formula.db
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45543
interpreted = N
texte = I think I have it solved. I was passing the Options variable from the Products page to the lineitems loop on the ShoppingCart page as [TextD] to get around the restrictions on variable names in a lineitems loop, but used [Woods] for the same value in Formulas.db. Therefore, when the lineitems loop called up Formulas.db, the lookup didn't have a value for [Woods]. If I used the same lookup outside a lineitems loop, even on ShoppingCarts.tpl, it worked correctly. This is what threw me.This is wrong in lineitems, but right outside lineitems: [lookup db=Woods.db&lookinfield=Woods&value=[URL][Woods][/URL]&returnfield=ExtraCost]This is right in lineitems: [lookup db=Woods.db&lookinfield=Woods&value=[URL][TextD][/URL]&returnfield=ExtraCost]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]It's not at all intuitive and the docs are damn little help. It would be just as secure to allow Price to be changed by a formula within the lineitems loop.I hope this helps someone else. I doubt this is unique to my experience.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:
I think I have it solved. I was passing the Options variable from the Products page to the lineitems loop on the ShoppingCart page as [TextD] to get around the restrictions on variable names in a lineitems loop, but used [Woods] for the same value in formulas.db. Therefore, when the lineitems loop called up formulas.db, the lookup didn't have a value for [Woods]. If I used the same lookup outside a lineitems loop, even on ShoppingCarts.tpl, it worked correctly. This is what threw me.This is wrong in lineitems, but right outside lineitems: [lookup db=Woods.db&lookinfield=Woods&value=[url][Woods][/URL]&returnfield=ExtraCost]This is right in lineitems: [lookup db=Woods.db&lookinfield=Woods&value=[url][TextD][/URL]&returnfield=ExtraCost]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]It's not at all intuitive and the docs are damn little help. It would be just as secure to allow Price to be changed by a formula within the lineitems loop.I hope this helps someone else. I doubt this is unique to my experience.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:
[WebDNA] Auto Expansion of .zip (2009)
Error: this shopping cart has already been submittedm (2004)
is [Bankres] an internal webcat variable? (1999)
Restricting templates from causing havoc (2000)
Date format problems (1997)
MS Commerce Comparison (long) (1998)
Line items in table cells (1997)
Cannot get subtotal to work (1997)
database visibility (2000)
RE: [WebDNA] XML Help (2009)
Off Topic: Frames Killer? (1998)
Can't add a field (1998)
Updating fields from different platforms (1998)
grep twice or a better way.... (2007)
Multiple catalog databases and showcart (1997)
WC2b15 File Corruption (1997)
WebCatalog 4.0.1b1 is now available (2000)
Questions To Answer (1997)
Extracting URL (2007)
taxrate - off by 1 cent (1997)