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 Fries BrainScan Software On 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:

    
  1. Re: Formulas.db not working ( Donovan Brooke 2006)
  2. Re: Formulas.db not working ( Brian Fries 2006)
  3. Re: Formulas.db not working ( Charles Kline 2006)
  4. Re: Formulas.db not working ( Donovan Brooke 2006)
  5. Re: Formulas.db not working ( Donovan Brooke 2006)
  6. Re: Formulas.db not working ( Charles Kline 2006)
  7. Re: Formulas.db not working ( Donovan Brooke 2006)
  8. Re: Formulas.db not working ( Charles Kline 2006)
  9. Re: Formulas.db not working ( "Dan Strong" 2006)
  10. Re: Formulas.db not working ( Charles Kline 2006)
  11. Re: Formulas.db not working ( Donovan Brooke 2006)
  12. Re: Formulas.db not working ( Charles Kline 2006)
  13. Re: Formulas.db not working ( Donovan Brooke 2006)
  14. Re: Formulas.db not working ( Donovan Brooke 2006)
  15. Re: Formulas.db not working ( Donovan Brooke 2006)
  16. Re: Formulas.db not working ( Gary Krockover 2006)
  17. Formulas.db not working ( Charles Kline 2006)
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 Fries BrainScan Software On 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)