Hi,
I use this script for acquire data from my sql DB with classic asp :
*data.asp*
> <!--#include file="JSON_2.0.4.asp"-->
> <!--#include file="JSON_UTIL_0.1.1.asp"-->
> <%
> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open Application("Conn")
> dim strsql
> strsql="SELECT field1 FROM table_name"
> QueryToJSONobj(objConn, strsql).Flush
> %>
and this to show the data:
*chart.asp*
> <script type="text/javascript">
> google.load('visualization', '1', {'packages':['corechart','table']});
> google.setOnLoadCallback(drawChart);
> function drawChart() {
> var jsonData = $.ajax({
> url: "Data.asp",
> dataType:"json",
> async: false,
> success: function(){alert('OK');},
> error: function(responseText){alert('err: ' + responseText);}
> }).responseText;
> var data = new google.visualization.DataTable(jsonData);
> var table = new
> google.visualization.Table(document.getElementById('chart_div2'));
> table.draw(data, {allowHtml: true, showRowNumber: true});
> }
> </script>
>
everything works fine, but i want to improve it.
i have to do multiple queries, soI want to send the query to data.asp from
chart.asp
The idea is that data.asp should become a dynamic page for retrieve any
query sent to it; something like:
Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open Application("Conn")
> dim strsql
> strsql=request("strsqlquery")
> QueryToJSONobj(objConn, strsql).Flush
one solution could be pass it from the url and use request.querystring:
> var jsonData = $.ajax({
> url: "Data.asp" + "?strsql=" + encodeURIComponent("SELECT field1 FROM
> table_name"),
> dataType:"json",
> async: false,
> success: function(){alert('OK');},
> error: function(responseText){alert('err: ' + responseText);}
> }).responseText;
it works, but there's a chars limit and with long complex queries doesn't
work...
maybe with ajax it's possible to do something better...
any suggestion?
Thanks!
Marco
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/LaIEf3zMVQ4J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
