Re: multiple price line in formula.db

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56323
interpreted = N
texte = What value are you getting? The retail price I'd imagine. You may have written it wrongly. You have cust=wholesale. Well that's not going to work. Did you mean [cust]=wholesale? That's pretty different. Is it possible to use ordinary variables in the formulas.db, or does it have to be ShoppingCarts headers/fields? Regards, Tim -- Tim Robinson idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 > From: Steve Chun > Reply-To: (WebDNA Talk) > Date: Mon, 23 Feb 2004 15:25:27 -0500 > To: (WebDNA Talk) > Subject: multiple price line in formula.db > > Having problems with getting one price for retail and one price for > wholesale customers. I have two different price fields and the > following in the formula.db for the price line. > > > [if cust=wholesale > [then][lookup > db=inventory.db&lookInField=SKU&value=[SKU]&returnField=wprice] > [/then] > [else] > [lookup db=inventory.db&lookInField=SKU&value=[SKU]&returnField=rprice] > [/else] > [/if] > > > Should I be using the [showif] instead? > > > > sc > > > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  2. Re: multiple price line in formula.db ( Gary Krockover 2004)
  3. Re: multiple price line in formula.db ( Steve Chun 2004)
  4. Re: multiple price line in formula.db ( Tim Robinson 2004)
  5. Re: multiple price line in formula.db ( Gary Krockover 2004)
  6. Re: multiple price line in formula.db ( Tim Robinson 2004)
  7. Re: multiple price line in formula.db ( Steve Chun 2004)
  8. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  9. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  10. Re: multiple price line in formula.db ( Tim Robinson 2004)
  11. Re: multiple price line in formula.db ( Steve Chun 2004)
  12. Re: multiple price line in formula.db ( Tim Robinson 2004)
  13. Re: multiple price line in formula.db ( Steve Chun 2004)
  14. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  15. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  16. multiple price line in formula.db ( Steve Chun 2004)
What value are you getting? The retail price I'd imagine. You may have written it wrongly. You have cust=wholesale. Well that's not going to work. Did you mean [cust]=wholesale? That's pretty different. Is it possible to use ordinary variables in the formulas.db, or does it have to be ShoppingCarts headers/fields? Regards, Tim -- Tim Robinson idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 > From: Steve Chun > Reply-To: (WebDNA Talk) > Date: Mon, 23 Feb 2004 15:25:27 -0500 > To: (WebDNA Talk) > Subject: multiple price line in formula.db > > Having problems with getting one price for retail and one price for > wholesale customers. I have two different price fields and the > following in the formula.db for the price line. > > > [if cust=wholesale > [then][lookup > db=inventory.db&lookInField=SKU&value=[SKU]&returnField=wprice] > [/then] > [else] > [lookup db=inventory.db&lookInField=SKU&value=[SKU]&returnField=rprice] > [/else] > [/if] > > > Should I be using the [showif] instead? > > > > sc > > > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ Tim Robinson

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:

Summing a field full of numbers ... (1997) Question about replacing words (1998) Using Currencies other than Dollars (1997) Why is deleting so slow? (2002) (1998) Nested tags count question (1997) 'does not contain' operator needed ... (1997) Bug? (1997) Multiple adding (1997) [Announce]: Web server security and password protection (1997) 2.0 Info (1997) Archive (Zip, Sit, Tgz) (2004) For those of you not on the WebCatalog Beta... (1997) SandBox and ImageMagick (2003) WebCatalog2 Feature Feedback (1996) Bulk capture for Authorize.net (2004) Group Updates (1998) [WebDNA] screen size (2011) WC 3.0.1 Mac days_to_date (1998) syntax question, not in online refernce (1997)