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:
Share cost of training videos! (1998)
search zip codes ranges (2003)
RE: Formulas.db + Users.db (1997)
[WebDNA] [BULK] WebDNA AJAX example wanted! (2010)
Authorize Net??? (2002)
WC2b15 File Corruption (1997)
Two options to consider (2008)
Can't add a field (1998)
Search technique question (1998)
WebCat & WebTen (1997)
Realtime Top 10 (1999)
Grep Search and Replace (2002)
[WebDNA] GREP Question (2009)
using showpage and showcart commands (1996)
Help! WebCat2 bug (1997)
suffix mapping for NT? (1997)
Simple way to create unique SKU (1997)
A little syntax help (1997)
[BULK] [WebDNA] Authorize.net SIM, Server Integration (2011)
RE: E-mailer error codes (1997)