Hello all,
I have an ASP page that needs to display a line chart generated on the fly. The data for the line chart is stored in an access DB. I want to write the data to an XML file and feed the chart from the file.
Part of the XML file needs to be the same. To be more specific - this is my XML file below:
<chart>
<chart_type>line</chart_type>
<axis_category size='10' />
<axis_value size = '10' />
<chart_data>
<row>
<null/>
<string>0%</string>
<string> </string>
<string> </string>
<string> </string>
<string>10%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>20%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>30%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>40%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>50%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>60%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>70%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>80%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>90%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>100%</string>
</row>
<row>
<string>Chart</string>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>379705000</number>
<number>979155000</number>
<number>2415574000</number>
<number>2787201000</number>
<number>3533686000</number>
<number>4726123000</number>
</row>
</chart_data>
</chart>
I want only the part where it says <number>value</number> to change based on data from the DB.
Any help will be appreciated.
Thanks.
I have an ASP page that needs to display a line chart generated on the fly. The data for the line chart is stored in an access DB. I want to write the data to an XML file and feed the chart from the file.
Part of the XML file needs to be the same. To be more specific - this is my XML file below:
<chart>
<chart_type>line</chart_type>
<axis_category size='10' />
<axis_value size = '10' />
<chart_data>
<row>
<null/>
<string>0%</string>
<string> </string>
<string> </string>
<string> </string>
<string>10%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>20%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>30%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>40%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>50%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>60%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>70%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>80%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>90%</string>
<string> </string>
<string> </string>
<string> </string>
<string> </string>
<string>100%</string>
</row>
<row>
<string>Chart</string>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>0</number>
<number>379705000</number>
<number>979155000</number>
<number>2415574000</number>
<number>2787201000</number>
<number>3533686000</number>
<number>4726123000</number>
</row>
</chart_data>
</chart>
I want only the part where it says <number>value</number> to change based on data from the DB.
Any help will be appreciated.
Thanks.