Re: [subtotal] problems -- help?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 16515
interpreted = N
texte = >I have created a special Formulas.db in the same directory as the >ShoppingCart.tmpl file, which looks like this: > >Name Formula >price [lookup >db=/greenmarket/catalog.txt&lookInField=sku&value=[sku]&returnField=[showif >[SpecialID]^101][price2][/showif][showif >[SpecialID]^221][price3][/showif][showif >[SpecialID]^334][price4][/showif][showif [SpecialID]^445][price5][/showif]]I see one problem with this that may help (but I haven't tried it since I don't have your databases). The returnField in a lookup should be price2, not [price2].price [lookup db=/greenmarket/catalog.txt&lookInField=sku&value=[sku]&returnField=[showif [SpecialID]^101]price2[/showif][showif [SpecialID]^221]price3[/showif][showif [SpecialID]^334]price4[/showif][showif [SpecialID]^445]price5[/showif]]I'm also concerned about the accuracy of the [SpecialID]^101 comparison. What if that 101 appears somewhere else futher down the text of SpecialID?Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [subtotal] problems -- help? (Technical Support 1998)
  2. Re: [subtotal] problems -- help? (Grant Hulbert 1998)
  3. [subtotal] problems -- help? (Technical Support 1998)
>I have created a special formulas.db in the same directory as the >ShoppingCart.tmpl file, which looks like this: > >Name Formula >price [lookup >db=/greenmarket/catalog.txt&lookInField=sku&value=[sku]&returnField=[showif >[SpecialID]^101][price2][/showif][showif >[SpecialID]^221][price3][/showif][showif >[SpecialID]^334][price4][/showif][showif [SpecialID]^445][price5][/showif]]I see one problem with this that may help (but I haven't tried it since I don't have your databases). The returnField in a lookup should be price2, not [price2].price [lookup db=/greenmarket/catalog.txt&lookInField=sku&value=[sku]&returnField=[showif [SpecialID]^101]price2[/showif][showif [SpecialID]^221]price3[/showif][showif [SpecialID]^334]price4[/showif][showif [SpecialID]^445]price5[/showif]]I'm also concerned about the accuracy of the [SpecialID]^101 comparison. What if that 101 appears somewhere else futher down the text of SpecialID?Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Grant Hulbert

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:

Searchable Archives? (2000) keep W* in front applescript? (1998) RE: Problems with dbcatalog.exe (1997) Deleting Orders (1997) cron script for housekeeping and running WebCatalog? (1999) WebCatalog2 Feature Feedback (1996) Multiple Pulldowns/Gary (1997) OFF-TOPIC: Check www.godaddy.com for me ... (2003) apostrophe in search item (1997) WebCat2b15MacPlugin - showing [math] (1997) PCS Frames (1997) List Address Changed! (1998) Online Docs? (1997) Summary search -- speed (1997) Date conversion (2002) expansion domain freak out (2003) frames & carts (1997) WebDNA Solutions ... sorry! (1997) Need correct syntax for writing to header2 (1999) send mail problem? (1997)