Re: multiple price line in formula.db
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56332
interpreted = N
texte = GaryThanks - but adding the parenthesis seems to have helped.Final code for the formulas.db is:price [If ("[cust]"="retail")][then][lookup db=inventory.db&lookInField=SKU&value=[SKU]&returnField=RETAILPRICE][/ then][else][lookup db=inventory.db&lookInField=SKU&value=[SKU]&returnField=WHOLESALEPRICE][ /else][/if]scOn Monday, February 23, 2004, at 11:40 PM, Gary Krockover wrote:> 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:
GaryThanks - but adding the parenthesis seems to have helped.Final code for the formulas.db is:price [If ("[cust]"="retail")][then][lookup db=inventory.db&lookInField=SKU&value=[SKU]&returnField=RETAILPRICE][/ then][else][lookup db=inventory.db&lookInField=SKU&value=[SKU]&returnField=WHOLESALEPRICE][ /else][/if]scOn Monday, February 23, 2004, at 11:40 PM, Gary Krockover wrote:> 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/
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:
[shownext] and descending order (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
[protect admin] (1997)
WebCat2b13MacPlugIn - [include] (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Waitfor file (2000)
Protect tag for large groups? (1999)
date tag not interpreted (2000)
Integrate login with phpBB or vBulletin (2006)
Add to Cart & List of Products (1997)
A question on sub-categories (1997)
REPOST: Large founditems loops (2000)
Deleting duplicates from a db (2000)
Reversed words (1997)
page redirect in webDNA (1997)
Emailer (1997)
taxRate is fine but taxTotal isn't (1997)
WebCat b13 CGI -shownext- (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Problem 2: Prefs file... (1997)