Using an existing recordset

[steve.tucker253175]

Is it possible to use an existing record set in a web chart?

I have a record set that uses a paramater to return specific data, how can I do this in a web chart?

Cheers

Steve

[Jimmy Wu]

You will not be able to use an existing recordset to get the data, but you can use the SQL query from that recordset to populate your data.

First you will have to create the chart using dynamic data with fake dynamic values.
You can then go into your DynamicWebCharts->Data directory in your site and open the untitled_data[num].php file that corresponds with your chart.
In this file you can find the line where this variable is set as the query:
$query_WADWCadmins

You can then set the SQL statement you have setup for the recordset into this variable making sure you specify a value for XLABEL and YVALUE to be selected from that query.