Re: Counting LineItems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32362
interpreted = N
texte = For one thing, the formulas.db is only used by WebCat itself for the fields listed on the doc page (price, taxable, etc.). You cannot just come up with a new variable and expect WebCat to know what to do with it. Your line will always display 0 because it is trying to subtract the string [discount] from the [subtotal], then format it.It is usually better to add a new line item for any discount, rather than trying to work outside of WebCat's system. Put a [addlineitem] on the page after you have calculated the total items and put your lookup there. Add a negative price and quantity 1...HTHJohn Peacock chas wrote: > > Hi, > > I'm back with a new iteration of relating quantity to discount. > > thanks to previous help John P,B,Brian I can carry a value of lineitems/quantity around in a header with - starting from the shoppingcart.tpl: > > [text]basket=[math]0[lineitems]+[quantity][/lineitems][/math][/text] > > then basket get put into a header: > > [SetHeader cart=[cart]]header40=[basket][/SetHeader] > > [header40] returns the right value on Invoice.tpl > > The problem is..... > > I want to apply a discount based on the value of [header40] > > here is what I have inserted after and outside the [lineitems][/lineitems] > >
> | Quantity Discount! | > $[format .2f][subtotal]-[discount][/format] | >
> > in formulas.db I have a line: > name
formula > > discount[lookup db=discount.db&lookInField=[quant]&value=[header40]&returnField=realprices¬Found=0] > > and a sample of discount.db looks like this > > quant listprice level discamnt realprices > 15959059 > 2 118 59 0 118 > 3 177 46.33 38.01 138.99 > 4 236 46.33 50.68 185.32 > and many many more.... > > where discamnt is the value i want subtracted from the subtotal. > > I get 0 always....in Quantity Discount! > > TIA > > Charley Conquest > Fresh Music > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
For one thing, the formulas.db is only used by WebCat itself for the fields listed on the doc page (price, taxable, etc.). You cannot just come up with a new variable and expect WebCat to know what to do with it. Your line will always display 0 because it is trying to subtract the string [discount] from the [subtotal], then format it.It is usually better to add a new line item for any discount, rather than trying to work outside of WebCat's system. Put a [addlineitem] on the page after you have calculated the total items and put your lookup there. Add a negative price and quantity 1...HTHJohn Peacock chas wrote: > > Hi, > > I'm back with a new iteration of relating quantity to discount. > > thanks to previous help John P,B,Brian I can carry a value of lineitems/quantity around in a header with - starting from the shoppingcart.tpl: > > [text]basket=[math]0[lineitems]+[quantity][/lineitems][/math][/text] > > then basket get put into a header: > > [SetHeader cart=[cart]]header40=[basket][/SetHeader] > > [header40] returns the right value on Invoice.tpl > > The problem is..... > > I want to apply a discount based on the value of [header40] > > here is what I have inserted after and outside the [lineitems][/lineitems] > > > | Quantity Discount! | > $[format .2f][subtotal]-[discount][/format] | >
> > in formulas.db I have a line: > nameformula > > discount[lookup db=discount.db&lookInField=[quant]&value=[header40]&returnField=realprices¬Found=0] > > and a sample of discount.db looks like this > > quant listprice level discamnt realprices > 15959059 > 2 118 59 0 118 > 3 177 46.33 38.01 138.99 > 4 236 46.33 50.68 185.32 > and many many more.... > > where discamnt is the value i want subtracted from the subtotal. > > I get 0 always....in Quantity Discount! > > TIA > > Charley Conquest > Fresh Music > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/
John Peacock
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:
carriage returns in data (1997)
Sendmail Question (2001)
ErrorMessages.db suggestion (1997)
[WebDNA] fastcgi 7+ & [cart]? (2010)
[WriteFile] problems (1997)
WC Database Format (1997)
emailer (1997)
webcat/webmerchant docs (1997)
Sort Order on a page search (1997)
WebCat2: Found Items syntax, etc. (1997)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
[WebDNA] Need a host (2015)
ShowNext (1997)
RE: protect tag on NT (1997)
Reversing [ipaddress] normalization (1998)
Cookies (1999)
Date search - yes or no (1997)
math with multiple [founditems] (1999)
database size? (1997)
Single Link browsing (1997)