Re: Formulas.db not working
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66178
interpreted = N
texte = First thing I notice is you say you say you have a "products.db", yet your price formula does a lookup in "catalog.txt".If I were you, I'd start by making sure the formula code works outside of the formulas.db with something like this on your page:[text]sku=1[/text]price: [math][lookup db=catalog.txt&lookInField=sku&value=[sku] &returnField=price]/2[/math]Brian FriesBrainScan SoftwareOn Feb 3, 2006, at 9:17 AM, 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/-------------------------------------------------------------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:
First thing I notice is you say you say you have a "products.db", yet your price formula does a lookup in "catalog.txt".If I were you, I'd start by making sure the formula code works outside of the formulas.db with something like this on your page:[text]sku=1[/text]price: [math][lookup db=catalog.txt&lookInField=sku&value=[sku] &returnField=price]/2[/math]Brian FriesBrainScan SoftwareOn Feb 3, 2006, at 9:17 AM, 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/-------------------------------------------------------------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/
Brian Fries
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:
Alternative colors? (2000)
Mime-Version in email header (1997)
Closing Databases (1998)
writing db to disk (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
faxing orders (2000)
Help name our technology! (1997)
[addlineitems] (1997)
set header in DB (no cart) (2003)
For those of you not on the WebCatalog Beta... (1997)
[OT] Shell script (2004)
Filemaker & WebCat (2001)
Number date (2006)
Spell Check (2000)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
[WebDNA] RSS Feed (2008)
URGENT: WebCatalog Stalls (1998)
quantity minimum problem (1997)
Shipping charge question (2003)
RE: Switching To NT (1999)