Re: multiple price line in formula.db
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56323
interpreted = N
texte = What value are you getting? The retail price I'd imagine.You may have written it wrongly. You have cust=wholesale. Well that's notgoing 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 haveto be ShoppingCarts headers/fields?Regards,Tim-- Tim Robinsonidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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/
Associated Messages, from the most recent to the oldest:
What value are you getting? The retail price I'd imagine.You may have written it wrongly. You have cust=wholesale. Well that's notgoing 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 haveto be ShoppingCarts headers/fields?Regards,Tim-- Tim Robinsonidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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/
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:
Summing a field full of numbers ... (1997)
Question about replacing words (1998)
Using Currencies other than Dollars (1997)
Why is deleting so slow? (2002)
(1998)
Nested tags count question (1997)
'does not contain' operator needed ... (1997)
Bug? (1997)
Multiple adding (1997)
[Announce]: Web server security and password protection (1997)
2.0 Info (1997)
Archive (Zip, Sit, Tgz) (2004)
For those of you not on the WebCatalog Beta... (1997)
SandBox and ImageMagick (2003)
WebCatalog2 Feature Feedback (1996)
Bulk capture for Authorize.net (2004)
Group Updates (1998)
[WebDNA] screen size (2011)
WC 3.0.1 Mac days_to_date (1998)
syntax question, not in online refernce (1997)