[subtotal] problems -- help?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16509
interpreted = N
texte = I searched the entire archives of the talk list, and couldn't find a direct answer. We are creating a wholesale site that presents different prices for a user, depending on their account number information. Thus, when they order from us, one user may see a different final price than another user.For example, when we list a price on a page, I am using a lot of [showif] commands to get the right price to show up. This is working really well, except when I get to the shopping cart, and specifically the [subtotal] part. It seems that the [subtotal] can only deal with the quantity*[price], but since my prices aren't in the [price] field of my database, it is not subtotaling properly.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]] (that's all on one line for those of you with text wrap on)Basically, every page of the website is properly passing the [SpecialID] variable, and all of the [price#] tags are valid database fields that have data. Right now, the [subtotal] for the shopping cart page shows up as: $0.00 no matter what I do.ANOTHER weird symptom... in order to make sure that the variables were being passed properly to the Formulas.db file, I replaced the price line with this in the Formulas.db file:price [showif [SpecialID]^101]100[/showif]0 The results of this were even more baffling... if I only had one product in the shopping cart, the [subtotal] = $0.00 If I had more than one, the [subtotal] = $1000 I would have expected the result to either be 0.00 or 1000... but not both.Can anyone help me with this problem? I am on a tight deadline and this snafu was not expected!-josh knauer ------------------------ Technical Support Center The EnviroLink Network http://www.envirolink.org/support/Ph: 412-683-6400 Fx: 412-683-8460The EnviroLink Network is membership-supported 501(c)(3) non-profit organization. If you would like to help support our work, please consider becoming a member: http://www.envirolink.org/membership
Associated Messages, from the most recent to the oldest:
I searched the entire archives of the
Talk List, and couldn't find a direct answer. We are creating a wholesale site that presents different prices for a user, depending on their account number information. Thus, when they order from us, one user may see a different final price than another user.For example, when we list a price on a page, I am using a lot of
[showif] commands to get the right price to show up. This is working really well, except when I get to the shopping cart, and specifically the [subtotal] part. It seems that the [subtotal] can only deal with the quantity*[price], but since my prices aren't in the [price] field of my database, it is not subtotaling properly.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]] (that's all on one line for those of you with text wrap on)Basically, every page of the website is properly passing the [SpecialID] variable, and all of the [price#] tags are valid database fields that have data. Right now, the [subtotal] for the shopping cart page shows up as: $0.00 no matter what I do.ANOTHER weird symptom... in order to make sure that the variables were being passed properly to the
formulas.db file, I replaced the price line with this in the
formulas.db file:price [showif [SpecialID]^101]100[/showif]0 The results of this were even more baffling... if I only had one product in the shopping cart, the [subtotal] = $0.00 If I had more than one, the [subtotal] = $1000 I would have expected the result to either be 0.00 or 1000... but not both.Can anyone help me with this problem? I am on a tight deadline and this snafu was not expected!-josh knauer ------------------------ Technical Support Center The EnviroLink Network http://www.envirolink.org/support/Ph: 412-683-6400 Fx: 412-683-8460The EnviroLink Network is membership-supported 501(c)(3) non-profit organization. If you would like to help support our work, please consider becoming a member: http://www.envirolink.org/membership
Technical Support
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:
WC2.0 Memory Requirements (1997)
WebCat2b15MacPlugin - [protect] (1997)
referrer usage (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Summary layout (1997)
Forbidden CGI Error (1997)
[WebDNA] ImageMagick troubleshooting (2009)
[protect admin] (1997)
Generating Report Totals (1997)
Long/Lat (2002)
A multi-processor savvy WebCatalog? (1997)
emailer (1997)
Error 11 (1996)
Country & Ship-to address & other fields ? (1997)
UPPERCASE (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
[OT] Colored source code in IE? (2007)
[WebDNA] using ^ within [showif] and [hideif] (2015)
Nested tags count question (1997)