Using an existing recordset
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
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
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.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.