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:
Search design (1997)
Signal Raised (1997)
No luck with taxes (1997)
[WebDNA] v.7 and eCommerce (2012)
system crashes, event log (1997)
[WebDNA] A note about the WebDNA Server 8.0.2 installer and Admin (2015)
HELP WITH DATES (1997)
[fileinfo . . .] (2000)
Newbie search question (between two dates) (2001)
RE: [WebDNA] Digital Ocean /WebDNA is not configured to accept (2019)
Kaaaaahhhhhhhnnnnnnn! (1997)
ShipToState question (1998)
Frames and WebCat (1997)
[OT] Bad Hard Drive? (2003)
Setting up shop (1997)
Image upload *CODE SAMPLE* (2000)
OT: Need some feedback, please. (2003)
webcat NT (1998)
[SHOWIF] (1997)
My solution... (1996)