Re: Formulas.db not working

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66173
interpreted = N
texte = Charles Kline wrote: > 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 > ----------- > > sku title price > 1 test_item 50 > > 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] Its probably just your email, but it appears there is a space after value=[SKU] Other than that, You reference two different product databases??? The heirarchy looks correct. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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)
Charles Kline wrote: > 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 > ----------- > > sku title price > 1 test_item 50 > > 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] Its probably just your email, but it appears there is a space after value=[SKU] Other than that, You reference two different product databases??? The heirarchy looks correct. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE EUCA Design Center <- Web Development (specializing in eCommerce),-> <- Custom Paint, Labels, and Specialty Signage. -> <- Home and Business Embellishment/Fabrication, -> <- Glass Blowing, and Art Glass -> PH/FAX:> 1 (608) 835-2476 Web:> http://www.egg.bz | http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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:

WebCat2.0 [format thousands .0f] no go (1997) cron script for housekeeping and running WebCatalog? (1999) WebCat2 - Getting to the browser's username/password data (1997) form crasehes server (1997) WebCatalog can't find database (1997) WebCatalog stalls (1998) F3 crashing server (1997) [WebDNA] new list (2008) with Link i need to (1997) taxTotal, grandTotal (1997) [protect] on NT? (1997) WebCat2final1 crashes (1997) Reversed words (1997) Search all Fields in a db (1997) 2.0 Info (1997) Mac to UNIX (2000) webcat and OS 8 (1997) multi-paragraph fields (1997) Re: (1997) Windows XP and cookies (2004)