Re: multiple price line in formula.db
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56328
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Steve Chun
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:
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
profiles (1999)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
Only charge card when product shipped ? (1997)
[WebDNA] includes with includes (2009)
Examples of cross-selling with WebCatalog? (1998)
redirect with frames (1997)
Bug when including a db file & [platform] (2000)
Secured Order Forms (1998)
WebDNA tags in WebMerchant email templates ... (1997)
problems with 2 tags (1997)
Signal Raised (1997)
Re:[input] context (1999)
[cart] clarification... (1997)
[protect] on NT? (1997)
Colors in cart (2002)
[append] (1997)
Caching problem... (2000)
[WebDNA] jumpstart me? - how to auto-upload to a remote server? (2010)
popups, netscape vs explorer (1997)