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:
Problem with formatting dates stored in db (2003)
[WebDNA] Talklist Archive & Twitter (2009)
Search/sort in URL Was: GuestBook example (1997)
Error:Too many nested [xxx] contexts (1997)
[carts] and databases (1997)
WebSTAR/WebCat is serving .db files! (1999)
blank page from template (1997)
BGcolor (1997)
More on IE5 (2000)
completed orders database (1997)
taxRate is fine but taxTotal isn't (1997)
&fieldsdir=ra truely random?? (2000)
[WebDNA] TCPConnect Slowness (2013)
Mac Vs WindowsNT (1997)
Attention SMSI - DOCS Error (2004)
One other big addition... (1997)
Credit card types (1997)
[OT] Disable/enable field (2003)
Snake Bites (1997)
WebCat2_Mac RETURNs in .db (1997)