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:
addlineitem is not saving a variable. (2004)
WebCat2.0 [format thousands .0f] no go (1997)
New public beta available (1997)
Physical Proximity searches (2000)
ShowNext example for GeneralStore (1997)
Multiple Attachments with Sendmail (2004)
[searchString] (1997)
no global [username] or [password] displayed ... (1997)
forming a SKU (1999)
UK credit card info follow-up (1997)
RE:It just Does't add up!!! (1997)
encrypted query string trouble on OSX (2001)
setting taxable to true (1997)
Uh...can someone help me out with the b10? (1997)
Help! WebCat2 bug (1997)
Forbidden CGI Error (1997)
Setting up shop (1997)
Mime Headers for Mail (1998)
To Do list (2003)
[index] (1997)