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:

RAM variables (1997) Help name our technology! (1997) Redirect in 4.0 (2000) More on the email templates (1997) What's New Date (2002) WebCat2b13MacPlugIn - More limits on [include] (1997) Can this be done? (1997) Apple event reply error (-1) (1997) Block air shipping choices (2006) EmailCompleted Clean Up (2001) [OT] What log analyzer do you use? (2000) Associative lookup style? + bit more (1997) format_to_days on NT (1997) Online reference (1997) Out of the woodwork (2007) Sort Order on a page search (1997) [WebDNA] Non-numbers entered into a field that asks for a (2008) [WebDNA] Why doesn't middle work as expected? (2009) SEARCH Peram (2003) Re:How to Display text in empty fields (1997)