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:
Updating a database once per day - An example (1998)
WebCatalog 2.0 b 15 mac (1997)
cookie length (1998)
WebCat for mass emailings (1997)
randomness (1997)
RE: Can a database get stomped by simultaneous access? (1997)
can pull down menu do a ONCHANGE= without Java script? (2000)
[WebDNA] AJAX module (2012)
File info on files with funky characters in their names (2003)
SOLVED - [WebDNA] Successful, working WebDNA7/CentOS install? (2013)
PSC recommends what date format yr 2000??? (1997)
Wireless WebDNA available today! (2000)
WebCatalog Hosting (1996)
Signal Raised Error (Part III) (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Re:no [search] with NT (1997)
and vs or vs not (1998)
Has this happened to you? (was:Emailer Chokes on bad address) (1997)
Dubble Sku's in a Database (1999)
Upgrading old WebCat Database Files (1997)