Re: multiple price line in formula.db

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56331
interpreted = N
texte = Yes. Actually I always use the parentheses and quotes for all if statements.... although I've seen people comment that you only need it if there's more than one comparison. > From: Gary Krockover > Reply-To: (WebDNA Talk) > Date: Mon, 23 Feb 2004 22:40:47 -0600 > To: (WebDNA Talk) > Subject: Re: multiple price line in formula.db > > Also, are the quotes neccessary, as in: > > [if "[cust]"="wholesale"] > > and I dunno why, but I always include the parenthesis, even if it is just > one comparison, so my adjusted statement would read: > > [if ("[cust]"="wholesale")] > > FWIW, > GK > > > At 10:08 PM 2/23/2004, you wrote: >> According to the docs, you can use "any form, text or math variable that is >> active on that page". >> >> Is there definitely a [cust] value on that page? Just enter [cust] somewhere >> and see if it populates with a value. >> >> Did you put a close square bracket? >> [if cust=wholesale] rather than [if cust=wholesale, as you first sent. >> >> >>> From: Steve Chun >>> Reply-To: (WebDNA Talk) >>> Date: Mon, 23 Feb 2004 23:07:59 -0500 >>> To: (WebDNA Talk) >>> Subject: Re: multiple price line in formula.db >>> >>> I'm getting $0 as the price. Tried changing it to [cust] but no luck. >>> >>> Thanks for the suggestion, I'll take another look at it now. >>> >>> sc >>> >>> >>> >>> >>> On Monday, February 23, 2004, at 10:40 PM, Tim Robinson wrote: >>> >>>> 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/ >>>> >>> >>> >>> ------------------------------------------------------------- >>> 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/ > > > ------------------------------------------------------------- > 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)
Yes. Actually I always use the parentheses and quotes for all if statements.... although I've seen people comment that you only need it if there's more than one comparison. > From: Gary Krockover > Reply-To: (WebDNA Talk) > Date: Mon, 23 Feb 2004 22:40:47 -0600 > To: (WebDNA Talk) > Subject: Re: multiple price line in formula.db > > Also, are the quotes neccessary, as in: > > [if "[cust]"="wholesale"] > > and I dunno why, but I always include the parenthesis, even if it is just > one comparison, so my adjusted statement would read: > > [if ("[cust]"="wholesale")] > > FWIW, > GK > > > At 10:08 PM 2/23/2004, you wrote: >> According to the docs, you can use "any form, text or math variable that is >> active on that page". >> >> Is there definitely a [cust] value on that page? Just enter [cust] somewhere >> and see if it populates with a value. >> >> Did you put a close square bracket? >> [if cust=wholesale] rather than [if cust=wholesale, as you first sent. >> >> >>> From: Steve Chun >>> Reply-To: (WebDNA Talk) >>> Date: Mon, 23 Feb 2004 23:07:59 -0500 >>> To: (WebDNA Talk) >>> Subject: Re: multiple price line in formula.db >>> >>> I'm getting $0 as the price. Tried changing it to [cust] but no luck. >>> >>> Thanks for the suggestion, I'll take another look at it now. >>> >>> sc >>> >>> >>> >>> >>> On Monday, February 23, 2004, at 10:40 PM, Tim Robinson wrote: >>> >>>> 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/ >>>> >>> >>> >>> ------------------------------------------------------------- >>> 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/ > > > ------------------------------------------------------------- > 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:

UPS Shipping (1999) Problems searching from a FORM (1997) wierd [cart] action! (1997) My server admin needs help ... (2004) New install permissions (2003) formula.db question (1997) Error 11 (1996) Test (2003) Error:Too many nested [xxx] contexts (1997) setting line item numbers (1998) expire headers in mac305b11 (1999) Product tag (2001) WebCat2 - Getting to the browser's username/password data (1997) creator code (1997) Re:No Data (1997) emailer (1997) RE: [WebDNA] German e-shop company proclaims "In Memory Computing" (2010) [SHOWIF AND/OR] (1997) Applescript error (1998) item sorting (1997)