texte = Hi everyone, I'm getting a very strange behaviour in a financial reporting table only 7columns wide, and 12 rows high (one row for each month). TD cells are filledwith a variety of information - a search, two lookups, and calculations onthose values. The table displays something different every time.... sometimes there isnothing in the cell, sometimes the correct value, and sometimes the WRONGvalue. But when I do a list variables at the bottom of the page, ALLvariables have the correct value!!I initially had the 12 month rows working as a loop, but the results wereeven worse! Having manually coded the 12 months, it's better but stillinconsistent. The loop solution should've worked properly, and so shouldthis.The values that seems to drop out most often are [SAP_SALES_1] and[BUDGET_SALES_1]. But to prove I'm not mad, the last two columns ALWAYSwork, even though they use these two fields for the calculations....Does anyone have any ideas? All help greatly appreciated as always. I'vecopied relevant code below.Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +612 9908 4837 [TEXT show=f]START_YEAR=2002[/TEXT]
Month Ending | COMS Sales | SAP Sales | Sys Var | Budget | Budget Var |
[Search db=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATEtype=date&saledatewbrk=,] [text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text] [/Search][TEXT show=F]SAP_SALES_1=[LOOKUPdb=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=SAP_SALES¬Found=TextIfNotFound][/TEXT][TEXT show=F]SYS_VAR_1=[math][SAP_SALES_1]-[interpret][[START_YEAR]_SALES_1][/interpret][/math][/TEXT][TEXT show=F]BUDGET_SALES_1=[LOOKUPdb=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=BUDGET_SALES¬Found=TextIfNotFound][/TEXT][TEXT show=F]BUDGET_VAR_1=[math][SAP_SALES_1]-[BUDGET_SALES_1][/math][/TEXT][TEXT show=F]VAR_PERCENT_1=[math][BUDGET_VAR_1]/[BUDGET_SALES_1]*100[/math][/TEXT] [DATE_RANGE1b] | [Format thousands.2f][interpret][[START_YEAR]_SALES_1][/interpret][/format] | [Format thousands][SAP_SALES_1][/format] | [Format thousands][SYS_VAR_1][/format] | [Format thousands][BUDGET_SALES_1][/format] | [Format thousands][BUDGET_VAR_1][/format] | [Format .2f][VAR_PERCENT_1][/format]% |
Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +612 9908 4837-------------------------------------------------------------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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi everyone, I'm getting a very strange behaviour in a financial reporting table only 7columns wide, and 12 rows high (one row for each month). TD cells are filledwith a variety of information - a search, two lookups, and calculations onthose values. The table displays something different every time.... sometimes there isnothing in the cell, sometimes the correct value, and sometimes the WRONGvalue. But when I do a list variables at the bottom of the page, ALLvariables have the correct value!!I initially had the 12 month rows working as a loop, but the results wereeven worse! Having manually coded the 12 months, it's better but stillinconsistent. The loop solution should've worked properly, and so shouldthis.The values that seems to drop out most often are [SAP_SALES_1] and[BUDGET_SALES_1]. But to prove I'm not mad, the last two columns ALWAYSwork, even though they use these two fields for the calculations....Does anyone have any ideas? All help greatly appreciated as always. I'vecopied relevant code below.Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +612 9908 4837 [TEXT show=f]START_YEAR=2002[/TEXT] Month Ending | COMS Sales | SAP Sales | Sys Var | Budget | Budget Var |
[Search db=data/directsales.db&rnSALEDATEdata=[DATE_RANGE1a],[DATE_RANGE1b]&SALEDATEtype=date&saledatewbrk=,] [text show=F][START_YEAR]_SALES_1=[Sum field=sale_total][/text] [/Search][TEXT show=F]SAP_SALES_1=[LOOKUPdb=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=SAP_SALES¬Found=TextIfNotFound][/TEXT][TEXT show=F]SYS_VAR_1=[math][SAP_SALES_1]-[interpret][[START_YEAR]_SALES_1][/interpret][/math][/TEXT][TEXT show=F]BUDGET_SALES_1=[LOOKUPdb=data/SAP_sales.db&value=[START_YEAR]_1&lookInField=SKU&returnField=BUDGET_SALES¬Found=TextIfNotFound][/TEXT][TEXT show=F]BUDGET_VAR_1=[math][SAP_SALES_1]-[BUDGET_SALES_1][/math][/TEXT][TEXT show=F]VAR_PERCENT_1=[math][BUDGET_VAR_1]/[BUDGET_SALES_1]*100[/math][/TEXT] [DATE_RANGE1b] | [Format thousands.2f][interpret][[START_YEAR]_SALES_1][/interpret][/format] | [Format thousands][SAP_SALES_1][/format] | [Format thousands][SYS_VAR_1][/format] | [Format thousands][BUDGET_SALES_1][/format] | [Format thousands][BUDGET_VAR_1][/format] | [Format .2f][VAR_PERCENT_1][/format]% |
Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +612 9908 4837-------------------------------------------------------------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://webdna.smithmicro.com/
Tim Robinson
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:
[WebDNA] SETCOOKIE (2009)
WebCat for Unix?? (1997)
Secure Server (1997)
maximu values for sendmail! (1997)
Date Sorting (1997)
SendTo more emails (1998)
Apache won't load after v5 install (more) (2003)
Country & Ship-to address & other fields ? (1997)
no global [username] or [password] displayed ... (1997)
Inventory Adjustment (2000)
counters from other site? (1998)
username = 115 (1999)
math variable security (2000)
creating a ShipCosts database (1997)
RE: Cookie Question (1999)
WebCat2b13MacPlugIn - [include] (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Database Updates (1997)
Emailer (1998)
format_to_days on NT (1997)