Re: Price and Formula.db

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45508
interpreted = N
texte = exactly the same issue as me. took me about 4 days and i have no idea what i did to get it to work but now it does and im not touching it.i think the formulas database is probably one of the worst parts of webcatalog in terms of not working the way you expect it to.its a subject that nobody likes cause nobody understands it when it doesn't work.My suggestion is to bin the whole lot and go with something a lot more easily understandable - you will go mental trying to figure it out.----- Original Message ----- From: Glenn Busbin To: WebCatalog Talk Sent: Wednesday, November 20, 2002 1:39 PM Subject: Re: Price and Formula.db > 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]+([l ookup db=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[look up db=Woods.db&lookinfield=Woods&value=[URL][Woods][/URL]&returnfield=ExtraCost ])[/Math] > Taxable F > UNITSHIPCOST 0.00 > SHIPCOST 0.00 > TAXRATE 0.00 > > Test 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]+([l ookup db=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[look up 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/ ------------------------------------------------------------- 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)
exactly the same issue as me. took me about 4 days and i have no idea what i did to get it to work but now it does and im not touching it.i think the formulas database is probably one of the worst parts of webcatalog in terms of not working the way you expect it to.its a subject that nobody likes cause nobody understands it when it doesn't work.My suggestion is to bin the whole lot and go with something a lot more easily understandable - you will go mental trying to figure it out.----- Original Message ----- From: Glenn Busbin To: WebCatalog Talk Sent: Wednesday, November 20, 2002 1:39 PM Subject: Re: Price and Formula.db > 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]+([l ookup db=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[look up db=Woods.db&lookinfield=Woods&value=[url][Woods][/URL]&returnfield=ExtraCost ])[/Math] > Taxable F > UNITSHIPCOST 0.00 > SHIPCOST 0.00 > TAXRATE 0.00 > > Test 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]+([l ookup db=Products.db&lookinfield=SKU&value=[URL[SKU][/URL&returnfield=Price]*[look up 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/ ------------------------------------------------------------- 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/ Andrew Simpson

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:

Dates - Search and Sorting (1999) shortening the cart (1998) won't serve .tpl -index.tpl gone, made test.tpl (2000) Re:PCS Customer submissions ? (1997) New global preference ... ??? (2000) rotating thumbnails (1997) Shared conversion under WebTen (1998) RE: ShowNext Command (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) rotating thumbnails (1997) WebCatalog Upgrade Pricing? (1997) No luck with taxes (1997) Replacing entry (1998) Attn: Bug in GeneralStore example b15 (1997) Plugin or CGI or both (1997) New Webcatalog for Mac (1997) WC2.0 Memory Requirements (1997) wish list (2002) Form based Redirect (2001) [Announce] Newest Commerce Site based on WebCatalog (1997)