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 ----------- 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 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)
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 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)