Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45506
interpreted = N
texte = I've tried everything I can think of, everything you guys suggested, and everything I can find in the archives. I have to fall back on the there's a bug in WC4.x Mac Classic and OS X that prevents Formulas.db from working.Here's the entire Formulas.db: 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][Woods][/URL]&returnfield=ExtraCost])[/Math] Taxable F UNITSHIPCOST 0.00 SHIPCOST 0.00 TAXRATE 0.00Test 1- This formula will put 0.00 in the Price field of a ShoppingCart template 100% of the time.Test 2- If I change the Price formula to: [Math][lookup db=Products.db&lookinfield=SKU&value=[URL][SKU][/URL]&returnfield=Price]+10[/Math]it will add 10 to the price from the Products.db 100% of the time.Test 3- If I put [Math=Show]X=[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][Woods][/URL]&returnfield=ExtraCost])[/Math]into a template with the SKU and Woods variables carried from another template, it will show the correct value for X. Test 4- The lookups will also return the correct values if put into a template as two separate lookups.Test 5- If I put the individual lookups into the lineitems loop in the ShoppingCart.tpl, it will they both return the correct values.SmithMicro, you created this mess. Although I don't expect you to respond to questions about your products, what do I tell the client and how do I get the calculated price into a shopping cart based on the price of the item plus the options? Using a password in the add command is insecure and therefore not an option.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've tried everything I can think of, everything you guys suggested, and everything I can find in the archives. I have to fall back on the there's a bug in WC4.x Mac Classic and OS X that prevents formulas.db from working.Here's the entire formulas.db: 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][Woods][/URL]&returnfield=ExtraCost])[/Math] Taxable F UNITSHIPCOST 0.00 SHIPCOST 0.00 TAXRATE 0.00Test 1- This formula will put 0.00 in the Price field of a ShoppingCart template 100% of the time.Test 2- If I change the Price formula to: [math][lookup db=Products.db&lookinfield=SKU&value=[url][SKU][/URL]&returnfield=Price]+10[/Math]it will add 10 to the price from the Products.db 100% of the time.Test 3- If I put [Math=Show]X=[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][Woods][/URL]&returnfield=ExtraCost])[/Math]into a template with the SKU and Woods variables carried from another template, it will show the correct value for X. Test 4- The lookups will also return the correct values if put into a template as two separate lookups.Test 5- If I put the individual lookups into the lineitems loop in the ShoppingCart.tpl, it will they both return the correct values.SmithMicro, you created this mess. Although I don't expect you to respond to questions about your products, what do I tell the client and how do I get the calculated price into a shopping cart based on the price of the item plus the options? Using a password in the add command is insecure and therefore not an option.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 and SQL (2003) Pithy questions on webcommerce & siteedit (1997) Linux ODBC and the ODBC Bridge (2000) Emailer problem (2000) RAM variables (1997) Reports of ErrorLog.txt not being written in Linux (2000) encrypt (2000) View Source from cache (1997) Text Variabels Not Passed To Include (2002) I assume it is a safe bet this does not help (1998) Sorting Numbers (1997) ReturnRaw and redirect (1997) Running 2 two WebCatalog.acgi's (1996) Missing Cart Information (2003) [OT] two domains one site... (2005) RE: Problems with dbcatalog.exe (1997) If Empty ? (1997) How To question on setting up downloads (1997) Unexpected error (1997) [WebDNA] Needing a new host.... (2013)