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:

    
  1. Re: [SMSI]Re: Price and Formula.db (Donovan 2002)
  2. Re: [SMSI]Re: Price and Formula.db (Scott Anderson 2002)
  3. [SMSI]Re: Price and Formula.db (Donovan 2002)
  4. Re: Price and Formula.db (John Peacock 2002)
  5. Re: Price and Formula.db (Donovan 2002)
  6. Re: Price and Formula.db (Glenn Busbin 2002)
  7. Re: Price and Formula.db (Donovan Brooke 2002)
  8. Re: Price and Formula.db (Gary Krockover 2002)
  9. Re: Price and Formula.db (Gary Krockover 2002)
  10. Re: Price and Formula.db (Gary Krockover 2002)
  11. Re: Price and Formula.db (Glenn Busbin 2002)
  12. Re: Price and Formula.db (Donovan Brooke 2002)
  13. Re: Price and Formula.db (Stuart Tremain 2002)
  14. Re: Price and Formula.db (Arturo Vargas 2002)
  15. Re: Price and Formula.db (Andrew Simpson 2002)
  16. Re: Price and Formula.db (Glenn Busbin 2002)
  17. Re: Price and Formula.db (Gary Krockover 2002)
  18. Re: Price and Formula.db (Donovan 2002)
  19. Re: Price and Formula.db (Glenn Busbin 2002)
  20. Re: Price and Formula.db (Donovan 2002)
  21. Re: Price and Formula.db (Andrew Simpson 2002)
  22. Re: Price and Formula.db (Glenn Busbin 2002)
  23. Re: Price and Formula.db (Donovan 2002)
  24. Re: Price and Formula.db (Andrew Simpson 2002)
  25. Re: Price and Formula.db (Andrew Simpson 2002)
  26. Re: Price and Formula.db (Glenn Busbin 2002)
  27. Re: Price and Formula.db (Andrew Simpson 2002)
  28. Price and Formula.db (Glenn Busbin 2002)
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:

View order not right (1997) TCP Connect (1999) Need a better [elapsedtime] (2000) Emailer (1997) 2.0Beta Command Ref (can't find this instruction) (1997) ReturnRaw followup (1999) taxTotal, grandTotal (1997) [OT] DOD again (2003) 2.1b3 --> way slow (1997) Emailer (1997) Loops in increments of .25 (2002) Upgrading (2003) PCS Frames (1997) Pass a form (2003) quotes (2004) help with duplicate records posted (1998) WebCommerce: Folder organization ? (1997) WebCatalog Use Question (1997) Whats going on with my SERIAL NUMBER??? (1998) Cookies and webcat (1997)