Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45509
interpreted = N
texte = I don't plan to understand this whole formulas.db deal, but have you tried using writefile to see the values passed to the formula. I usually copy the whole formula to writefile without using the [math] just to see what is going on.Art-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Glenn Busbin Sent: Tuesday, November 19, 2002 4:40 PM To: WebCatalog Talk Subject: Re: Price and Formula.dbI'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=Extra Cost])[/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=Extra Cost])[/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/ ------------------------------------------------------------- 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 don't plan to understand this whole formulas.db deal, but have you tried using writefile to see the values passed to the formula. I usually copy the whole formula to writefile without using the [math] just to see what is going on.Art-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Glenn Busbin Sent: Tuesday, November 19, 2002 4:40 PM To: WebCatalog Talk Subject: Re: Price and Formula.dbI'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=Extra Cost])[/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=Extra Cost])[/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/ ------------------------------------------------------------- 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/ Arturo Vargas

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:

WebCatalog2 Feature Feedback (1996) Separate SSL Server (1997) Don't know if this is a silly question... (2003) Listfiles (1998) Dark Horse Comics success story (1997) [isfile] ? (1997) [TaxableTotal] - not working with AOL and IE (1997) Running 2 two WebCatalog.acgi's (1996) Emailer (WebCat2) (1997) Using Cookie for client specific info? (1997) Re:Merging databases (1997) WebCatalog for guestbook ? (1997) proper username/password *w/out* the authenticate dialog. (2000) Template Cache problem (2000) My Eyes doth deceive me (2002) shipcost (1997) Nesting format tags (1997) WebCat b13 CGI -shownext- (1997) WebCat and WebTV (1997) RE: Cookies? (1997)