Re: formula???

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34800
interpreted = N
texte = price is already a header in the lineitems portion of the orderfile (do we call those headers down there?). You don't have to try to store it somewhere else in the orderfile.Glenn Busbin wrote:> >are you using an add command or an [addlineitem] context? > > Add command. > HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=mydatabase.db&sku=[url][sku][/ > url]>Add to your Shopping Cart > > >Add a [writefile] to your formula to write out the value of > >[quantity] to make sure it's what you think it is. > > Good suggestion. My formula is: > Name Formula > price [math][showif [quantity]>0]0.9*[/showif][lookup > db=mydatabase.db&lookInField=sku&value=[sku]&returnField=price][/math] > [writefile file=test&secure=F][quantity][/writefile] > > [quantity] ISN'T what it should be. It's always 1, no matter what it is on > the Invoice.tpl or ShoppingCart.tpl pages. > > So it looks like I need to....what? Put the [quantity] info into a header > and use that in the formula? > > Thanks, > 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: formula??? (John Peacock 2000)
  2. Re: formula??? (John Peacock 2000)
  3. Re: formula??? (Glenn Busbin 2000)
  4. Re: formula??? (John Butler 2000)
  5. Re: formula??? (John Butler 2000)
  6. Re: formula??? (Glenn Busbin 2000)
  7. Re: formula??? (WebDNA Support 2000)
  8. Re: formula??? (Glenn Busbin 2000)
  9. Re: formula??? (Arturo Vargas 2000)
  10. Re: formula??? (WebDNA Support 2000)
  11. Re: formula??? (John Butler 2000)
  12. Re: formula??? (Glenn Busbin 2000)
  13. Re: formula??? (John Peacock 2000)
  14. Re: formula??? (Glenn Busbin 2000)
  15. Re: formula??? (John Peacock 2000)
  16. formula??? (Arturo Vargas 2000)
price is already a header in the lineitems portion of the orderfile (do we call those headers down there?). You don't have to try to store it somewhere else in the orderfile.Glenn Busbin wrote:> >are you using an add command or an [addlineitem] context? > > Add command. > HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=mydatabase.db&sku=[url][sku][/ > url]>Add to your Shopping Cart > > >Add a [writefile] to your formula to write out the value of > >[quantity] to make sure it's what you think it is. > > Good suggestion. My formula is: > Name Formula > price [math][showif [quantity]>0]0.9*[/showif][lookup > db=mydatabase.db&lookInField=sku&value=[sku]&returnField=price][/math] > [writefile file=test&secure=F][quantity][/writefile] > > [quantity] ISN'T what it should be. It's always 1, no matter what it is on > the Invoice.tpl or ShoppingCart.tpl pages. > > So it looks like I need to....what? Put the [quantity] info into a header > and use that in the formula? > > Thanks, > 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/ John Butler

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:

WCS Newbie question (1997) when is failing to [URL]ize values in a comparison risky? (1999) Problem 2: Prefs file... (1997) Lineitems not showing up in ThankYou page (2006) [WebDNA] Different responses for the same commands ... (2011) no time stamp & different times from emailer (1998) [group] ? (1997) re: How can I record purchases to a database? (1998) Removing carriage returns and line feeds (2006) WebCat with WebTen (1998) Search design (1997) problem (1998) [Reload mydata.db] (1998) Me know logical no need (2002) PSC recommends what date format yr 2000??? (1997) Problem with [Search] inside of [Loop]? (1997) Ok here is a question? (1997) [WebDNA] HTML Symbol Entities (2009) I need Typhoon Pro Tonight! (1999) Frames and WebCat (1997)