Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66170
interpreted = N
texte = On Feb 3, 2006, at 12:09 PM, Donovan Brooke wrote:> Gary Krockover wrote:>>> Been a while myself->> Don't you have to do some math on the price, i.e.:>> price
[showif [sku]=12345][math][lookup >> db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/ >> math][/showif]>> Gary>>> Gary, you are right.>> I appologise.. I didn't see the "/" symbol.>> Try Gary's suggestion.>That does not seem to be it. I have tried this and also just put a value in there instead of a formula. It does not seem to be modifying the value. Here is what I have:products.db-----------skutitleprice1test_item50formulas.db-----------price[math][lookup db=catalog.txt&lookInField=sku&value=[sku] &returnField=price]/2[/math]test.tpl--------[addlineitem cart=5678&sku=1&db=products.db]quantity=5&textA=Red[/ addlineitem][orderfile cart=5678][lineitems][sku], [price], [quantity]
[/lineItems][/orderfile]-------------------------------------------------------------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:
On Feb 3, 2006, at 12:09 PM, Donovan Brooke wrote:> Gary Krockover wrote:>>> Been a while myself->> Don't you have to do some math on the price, i.e.:>> price[showif [sku]=12345][math][lookup >> db=catalog.txt&lookInField=sku&value=[sku]&returnField=price]/2[/ >> math][/showif]>> Gary>>> Gary, you are right.>> I appologise.. I didn't see the "/" symbol.>> Try Gary's suggestion.>That does not seem to be it. I have tried this and also just put a value in there instead of a formula. It does not seem to be modifying the value. Here is what I have:products.db-----------skutitleprice1test_item50formulas.db-----------price[math][lookup db=catalog.txt&lookInField=sku&value=[sku] &returnField=price]/2[/math]test.tpl--------[addlineitem cart=5678&sku=1&db=products.db]quantity=5&textA=Red[/ addlineitem][orderfile cart=5678][lineitems][sku], [price], [quantity]
[/lineItems][/orderfile]-------------------------------------------------------------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/
Charles Kline
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:
Re:no [search] with NT (1997)
RequiredFields notes ... (1997)
UPS Shipping Calc - 2 items (2000)
Retaining formatting (2000)
possible, WebCat2.0 and checkboxes-restated (1997)
Not really WebCat- (1997)
Share Bulletin Board? (1998)
Searching Multiple DBs (1997)
OT Pager notification of completed orders (1998)
WebCat2b15MacPlugin - [protect] (1997)
Add (1998)
2.1b3 --> way slow (1997)
MacAuthorize and WebMerchant (1997)
search context w shownext works! (1997)
[TaxableTotal] - not working with AOL and IE (1997)
String manipulation in Webcatalog (2001)
showing *all* name/value pairs with [search] (2003)
[if] (2003)
math a various prices (1997)
Protect vs Authenicate (1997)