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 ifstatements.... although I've seen people comment that you only need it ifthere'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:
Yes. Actually I always use the parentheses and quotes for all ifstatements.... although I've seen people comment that you only need it ifthere'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)