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:
RE: Upload (1998)
HELP WITH DATES (1997)
Multiple Newcarts (1996)
can WC render sites out? (1997)
filemaker - orderfile (1997)
different ship dates and shopping carts -- how to? (1997)
Server Freeze (1998)
notification solutions (1997)
Currency Conversion (2003)
$Replace with [founditems] (1997)
Bug? (1997)
WebCat2 beta 11 - new prefs ... (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
So many lookers, hey smith micro (2003)
[addlineitems] (1997)
A little syntax help (1997)
Email problem (1998)
Location of Webcat site in folder hierarchy (1997)
RAM variables (1997)
Limiting user access to .tmpl files (1997)