Re: Change Subtotal

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 36461
interpreted = N
texte = Glenn,> Set the value of the discount using the Formulas.db.I'm trying to do this. This is what I am doing. In the invoice.tpl page I: [AddlineItem cart=[cart]&sku=2&db=dbname][/Addlineitem]This works well but with the set price I have for Discount(sku 2) in the database with set price $50. So it subtracts $50.In the formulas.db I put this formula: Discount [lookup db=dbname&lookinfield=sku&value=2&returnfield=price]price=[math][subtotal]*. 50[/math]]Granted to say it does not work.Any thoughts?S-------------------------------------------------------------- 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: Change Subtotal (Stephen Russo 2000)
  2. Re: Change Subtotal (Stephen Russo 2000)
  3. Re: Change Subtotal (Stephen Russo 2000)
  4. Re: Change Subtotal (Stephen Russo 2000)
  5. Re: Change Subtotal (John Butler 2000)
  6. Re: Change Subtotal (Stephen Russo 2000)
  7. Re: Change Subtotal (Peter Ostry 2000)
  8. Re: Change Subtotal (Peter Ostry 2000)
  9. Re: Change Subtotal (Peter Ostry 2000)
  10. Re: Change Subtotal (Stephen Russo 2000)
  11. Re: Change Subtotal (Stephen Russo 2000)
  12. Re: Change Subtotal (Stephen Russo 2000)
  13. Re: Change Subtotal (John Butler 2000)
  14. Re: Change Subtotal (Glenn Busbin 2000)
  15. Re: Change Subtotal (Stephen Russo 2000)
  16. Re: Change Subtotal (Stephen Russo 2000)
  17. Re: Change Subtotal (Glenn Busbin 2000)
  18. Re: Change Subtotal (Stephen Russo 2000)
  19. Re: Change Subtotal (Stephen Russo 2000)
  20. Re: Change Subtotal (John Butler 2000)
  21. Re: Change Subtotal (Glenn Busbin 2000)
  22. Re: Change Subtotal (Glenn Busbin 2000)
  23. Re: Change Subtotal (Glenn Busbin 2000)
  24. Re: Change Subtotal (Glenn Busbin 2000)
  25. Re: Change Subtotal (Stephen Russo 2000)
  26. Change Subtotal (Stephen Russo 2000)
  27. Re: Change Subtotal (Glenn Busbin 2000)
  28. Re: Change Subtotal (Glenn Busbin 2000)
Glenn,> Set the value of the discount using the formulas.db.I'm trying to do this. This is what I am doing. In the invoice.tpl page I: [AddlineItem cart=[cart]&sku=2&db=dbname][/Addlineitem]This works well but with the set price I have for Discount(sku 2) in the database with set price $50. So it subtracts $50.In the formulas.db I put this formula: Discount [lookup db=dbname&lookinfield=sku&value=2&returnfield=price]price=[math][subtotal]*. 50[/math]]Granted to say it does not work.Any thoughts?S-------------------------------------------------------------- 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/ Stephen Russo

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:

unable to launch acgi in WebCat (1997) Price override (2004) [protect] on NT? (1997) WebCat2b12plugin - [search] is broken ... not! (1997) WC2b15 File Corruption (1997) FM PRO Compatibility Issue - Single Database w/o Conversions (1997) Running _every_ page through WebCat ? (1997) Plugin or CGI or both (1997) webcat 2.1 new cart fields - please explain more (1998) [WebDNA] CICADA (2009) Random Number Generator works for Ranges of Numbers (1997) Database Security Rev., (2002) WebCat2b13 Command Reference Doc error (1997) Pithy questions on webcommerce & siteedit (1997) removing programming logic white space (2003) multi-paragraph fields (1997) triggers (2002) Bug at start of Apache 2 with iTools 7 (2003) Cart Question (1998) suffix mapping for NT? (1997)