math problems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28011
interpreted = N
texte = The online grocery store...UGH!! I just received an order with the following totals:$166.42 Subtotal $3.64 Tax $373248.05 CRV $16.64 Delivery $373434.75 Grand TotalThe CRV equation is:$[format .2f][math]CRVFigure=[lineitems][Quantity]*[CRV]+[/lineitems]0[/math][/format ] CRVOf course the only time that the CRV equation is even used is when the customer purchases soft drinks. I have received several orders that are calculated fine, no odd CRV totals...then on occasion I get something crazy like this. Is there something about the equation that could be unstable?The above total was generated from a thankyou.html and [sendmail]'ed to me as confirmation. On that same thankyou.html, each [lineitem] is found in the database...product.txt by SKU and appropriate information (including CRV the total) is then written to a new database...productspurchased.txt.>From this new productpurchased.txt database, daily totals and receipts are generated with the following equation:$[format 100.2f][math]CRVFigure=[search db=s4fpurchased.txt&eqCartdatarq=[Cart]&neDelivereddatarq=ND&grCRVdatarq=0.0 0&CRVdatatype=num][founditems][Quantity]*[CRV]+[/founditems][/search]0[/math ][/format]These totals are being generated correctly from the order placed earlier with the crazy CRV total...so that tells me that there's nothing wrong with the [CRV] coming from the original database.In order to troubleshoot this craziness, I've gone into the site and purchased the exact same items as this shopper, and my CRV totals are [sendmail]'ed correctly at $.10 Does anyone have any ideas as to what could be going on, or how else I may troubleshoot the problem. It seems as though this erros is occurring sporadically, and I haven't a clue where to begin correcting it.Any ideas and/or suggestions would be greatly appreciated!!!! ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
The online grocery store...UGH!! I just received an order with the following totals:$166.42 Subtotal $3.64 Tax $373248.05 CRV $16.64 Delivery $373434.75 Grand TotalThe CRV equation is:$[format .2f][math]CRVFigure=[lineitems][Quantity]*[CRV]+[/lineitems]0[/math][/format ] CRVOf course the only time that the CRV equation is even used is when the customer purchases soft drinks. I have received several orders that are calculated fine, no odd CRV totals...then on occasion I get something crazy like this. Is there something about the equation that could be unstable?The above total was generated from a thankyou.html and [sendmail]'ed to me as confirmation. On that same thankyou.html, each [lineitem] is found in the database...product.txt by SKU and appropriate information (including CRV the total) is then written to a new database...productspurchased.txt.>From this new productpurchased.txt database, daily totals and receipts are generated with the following equation:$[format 100.2f][math]CRVFigure=[search db=s4fpurchased.txt&eqCartdatarq=[cart]&neDelivereddatarq=ND&grCRVdatarq=0.0 0&CRVdatatype=num][founditems][Quantity]*[CRV]+[/founditems][/search]0[/math ][/format]These totals are being generated correctly from the order placed earlier with the crazy CRV total...so that tells me that there's nothing wrong with the [CRV] coming from the original database.In order to troubleshoot this craziness, I've gone into the site and purchased the exact same items as this shopper, and my CRV totals are [sendmail]'ed correctly at $.10 Does anyone have any ideas as to what could be going on, or how else I may troubleshoot the problem. It seems as though this erros is occurring sporadically, and I haven't a clue where to begin correcting it.Any ideas and/or suggestions would be greatly appreciated!!!! ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Kimberly D Ingram
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:
Sort Issue? (2000)
[WebDNA] WebDNA as cgi app (was WebSite Examples) (2008)
Webcat no longer supported? (2006)
Document Contains No Data (1998)
WebCommerce: Folder organization ? (1997)
The word TYPE in search contexts and fields (1998)
Field name-subcategory (1997)
[format 40s]text[/format] doesn't work (1997)
Out of the woodwork (2007)
WebCat2b12 CGI Mac - [shownext] problem (1997)
how to add to triggers.db (1998)
OT: SEO (2007)
Multiple prices (1997)
[WebDNA] Which linux distros for webdna? (2008)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
won't serve .tpl (2000)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
This list needs a digest: rant, rave... (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Checkboxes (1998)