Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66174
interpreted = N
texte = I realize there is an error in the formula here catalog.txt is actually correctly using products.db in the actual fileOn Feb 3, 2006, at 12:17 PM, Charles Kline wrote:> 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> ----------->> skutitleprice> 1test_item50>> formulas.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/--RightCode, Inc.900 Briggs Road #130Mount Laurel, NJ 08054P: 856.608.7908F: 856.439.0154E: ckline@rightcode.net-------------------------------------------------------------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:
I realize there is an error in the formula here catalog.txt is actually correctly using products.db in the actual fileOn Feb 3, 2006, at 12:17 PM, Charles Kline wrote:> 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> ----------->> skutitleprice> 1test_item50>> formulas.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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/--RightCode, Inc.900 Briggs Road #130Mount Laurel, NJ 08054P: 856.608.7908F: 856.439.0154E: ckline@rightcode.net-------------------------------------------------------------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:
Calculating multiple shipping... (1997)
[WebDNA] WebDNA Roll Call (2013)
text area input and convertchars (2002)
Need formatting help (1998)
Erotic Sites (1997)
WebCatalog/WebMerchant 2.1.1 (PC + Mac) Available (1998)
[OT] Mozilla | Was: R.I.P. Netscape (2003)
Smith Micro Customer Service Sucks (2008)
searchable list archive (1997)
Image maps/Webcat (1997)
[BULK] [WebDNA] [BULK] looking for the holy grail of hosting still (2013)
form data submission gets truncated (1997)
Error 11 (1996)
WC2b15 File Corruption (1997)
Users.db [encrypt seed=????] (1998)
Other then credit cards-how? (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
MacAuthorize hub, no modal password dialog? (1997)
firewall ports for Mac OS X/WebCatalog (2001)
Putting [cart] into a database (2003)