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 [lookupdb=/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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 [lookupdb=/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 | Typhoon619/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)