Re: multiple price line in formula.db

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56329
interpreted = N
texte = What does it get populated with? You may need to URL [cust]. [if [url][cust][/url]=wholesale] > From: Steve Chun > Reply-To: (WebDNA Talk) > Date: Mon, 23 Feb 2004 23:39:15 -0500 > To: (WebDNA Talk) > Subject: Re: multiple price line in formula.db > > Was missing that closing bracket but definitely a [cust] value on the > page that gets populated. > > Now i get the retail price and not the wholesale price. > > > Guess I'll comb through the docs again. > > > sc > > > > > On Monday, February 23, 2004, at 11:08 PM, Tim Robinson 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)
What does it get populated with? You may need to URL [cust]. [if [url][cust][/url]=wholesale] > From: Steve Chun > Reply-To: (WebDNA Talk) > Date: Mon, 23 Feb 2004 23:39:15 -0500 > To: (WebDNA Talk) > Subject: Re: multiple price line in formula.db > > Was missing that closing bracket but definitely a [cust] value on the > page that gets populated. > > Now i get the retail price and not the wholesale price. > > > Guess I'll comb through the docs again. > > > sc > > > > > On Monday, February 23, 2004, at 11:08 PM, Tim Robinson 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:

lookup and two records? (1997) 2nd WebCatalog2 Feature Request (1996) 2.0.1 new commands and contexts (1997) Database Advice (1996) auto-stripping of spaces (1997) OK, here goes... (1997) WebCatalog can't find database (1997) Text data with spaces in them... (1997) syntax question, not in online refernce (1997) Search for specific characters in a string (2005) Re:Multiple appends with checkboxes (1998) WebCatalog2 Feature Feedback (1996) WebDNA-Talk Digest mode broken (1997) WebCat2: multiple currency support (1997) [WebDNA] CICADA (2009) Special characters in field names (1998) help needed: Non-english characters in WebCatalog (1997) Items XX to XX shown (1997) Custom WebCat Prefs ... (1997) Intermitent problem using [referrer] (1997)