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:
WC Database Format (1997)
Sorta OT: Printing From Browser Window (2001)
Multiple fields on 1 input (1997)
Major Security Hole IIS NT (1998)
Some Questions (1997)
Searching multiple fields from one form field (1997)
unable to launch acgi in WebCat (1997)
How nuch ram??? (1997)
Almost a there but..bye bye NetCloak (1997)
SiteGuard Use Question (1997)
Sort Order on a page search (1997)
WebDNA Life Cycle (was Form POSTing with LONG variable) (2007)
Kill the webcat process (2000)
Logical and or in [hideif] (1997)
refreshing IE with posted .tmpl (1997)
Great product and great job ! (1997)
Search returns all, not 20 (1997)
For those of you not on the WebCatalog Beta... (1997)
ReturnRaw and redirect one last question (1997)
Country & Ship-to address & other fields ? (1997)