Re: formula???
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 34776
interpreted = N
texte = I have always found formulas.db to be the least understood, yet the most powerful feature within WebCat. We use it constantly, because our primary database contains 1 record for both cloth and paper editions. I must look up the price in a secondary table based on the value of TextB:price [lookup db=../IMPRINT.db&lookinfield=ISBN&value=[textb] &returnfield=USPrice]That is a tab between price and the formula. This works like magic.John PeacockGlenn Busbin wrote: > > I don't think anyone knows. In fact, I posted two messages to the list > last week asking the same thing. > > The docs say that you can use the formulas database to set [price] > according to different situations, but I sure can't get it to work. > > According to the docs: > >[math][showif [username]=GRANT]0.0*[/showif][lookup > >db=catalog.txt&lookInField=sku&value=[sku]&returnField=price][/math] > > > >This example would set the price to $0 if the user was logged in as > >GRANT, otherwise the price would be unchanged. > > Lottsa luck in getting something like that to work, though. > > >I thank you in advance. > > > >In this page I am creating a customer has to be able to order one product > >are regular price (29.95) but if they buy 2 or more then the price is > >(19.95)each > >How can I accomplish this?? > >Any suggestions? > > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I have always found formulas.db to be the least understood, yet the most powerful feature within WebCat. We use it constantly, because our primary database contains 1 record for both cloth and paper editions. I must look up the price in a secondary table based on the value of TextB:price [lookup db=../IMPRINT.db&lookinfield=ISBN&value=[textb] &returnfield=USPrice]That is a tab between price and the formula. This works like magic.John PeacockGlenn Busbin wrote: > > I don't think anyone knows. In fact, I posted two messages to the list > last week asking the same thing. > > The docs say that you can use the formulas database to set [price] > according to different situations, but I sure can't get it to work. > > According to the docs: > >[math][showif [username]=GRANT]0.0*[/showif][lookup > >db=catalog.txt&lookInField=sku&value=[sku]&returnField=price][/math] > > > >This example would set the price to $0 if the user was logged in as > >GRANT, otherwise the price would be unchanged. > > Lottsa luck in getting something like that to work, though. > > >I thank you in advance. > > > >In this page I am creating a customer has to be able to order one product > >are regular price (29.95) but if they buy 2 or more then the price is > >(19.95)each > >How can I accomplish this?? > >Any suggestions? > > > > ------------------------------------------------------------- > 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://search.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://search.smithmicro.com/
John Peacock
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:
Template Security error (1997)
[OT] Robust order processing (2003)
Ok here is a question? (1997)
WebDNA / Filemaker / Special characters (2000)
possible, WebCat2.0 and checkboxes-restated (1997)
Using Applescript to process WebCatalog functions (1998)
WebCat2 - [format thousands] (1997)
Quit revisited (1997)
Fwd: FW: Purchase Command error (1997)
Help with database strategy (1998)
BGcolor (1997)
Follow-up to listfiles bug report ... (2003)
RE: Recursion & WebDNA (1999)
[WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (2009)
Nested tags count question (1997)
2 Questions (2001)
Database Crash (2001)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Robert Minor duplicate mail (1997)
New Command prefs ... (1997)