ok i got it to work. i guess it was more of a setup problem (localhost). I posted it out on my free webhost and it works fine.
http://aspspider.info/gtgeek/json.aspx?tqx=version:0.6;reqId:1;sig:5277771;out:json;responseHandler:myQueryHandler next challenge is .net datatable -> json table, has anyone done that? On Jul 20, 4:52 am, richardb <[email protected]> wrote: > You may need to explicitly set the content type on the Response > > Response.ContentType = "text/plain"; > Response.Charset = "UTF-8"; > > On Jul 20, 12:14 am, gtgeek <[email protected]> wrote: > > > > > ok, so bacially after my research i've decided to implement my own > > data source using asp.net as VizBoy suggested option > > 2:http://groups.google.com/group/google-visualization-api/browse_thread... > > > trying to > > mimic:http://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ&range=B... > > > which should > > feed:http://code.google.com/apis/ajax/playground/?type=visualization#inten... > > > I created a single file asp.net file myds.aspx it will take in ? > > tqx=out:json;reqId:1234 etc. > > It is a single accept any parameter, but will process as the > > documented:http://code.google.com/apis/visualization/documentation/dev/implement... > > > It does return a json string as text but the example doesn't seem to > > accept it. > > > please take a look and let me know if i am missing something > > > <%@ Page Language="VB" %> > > <script runat="server"> > > Dim reqId as string > > Dim version as string > > Dim responseHandler as string > > Dim outFileName as string > > Dim out as string > > Dim sig as string > > Dim status as string > > Dim warnings as string > > Dim errors as string > > Dim table as string > > > Private Sub Page_Load(ByVal sender As Object, ByVal e As > > System.EventArgs) > > ParseTQX > > PerformQuery > > SendResponse(reqId, version, responseHandler, out, outFileName, > > status, warnings, errors, table) > > End Sub > > > Private Sub PerformQuery() > > status = "ok" > > sig = "1068688546" > > version = "0.6" > > table = "{cols:[{id:'B',label:'Country > > code',type:'string',pattern:''}, > > {id:'C',label:'Population',type:'number',pattern:'#0.###############'}, > > {id:'D',label:'Population > > Density',type:'number',pattern:'#0.###############'}],rows:[{c: > > [{v:'CN'},{v:1.32297E9,f:'1322970000'},{v:137.0,f:'137'}]},{c: > > [{v:'IN'},{v:1.13013E9,f:'1130130000'},{v:336.0,f:'336'}]},{c: > > [{v:'US'},{v:3.03605941E8,f:'303605941'},{v:31.0,f:'31'}]},{c: > > [{v:'ID'},{v:2.31627E8,f:'231627000'},{v:117.0,f:'117'}]},{c:[{v:'BR'}, > > {v:1.86315468E8,f:'186315468'},{v:22.0,f:'22'}]},{c:[{v:'PK'},{v: > > 1.626525E8,f:'162652500'},{v:198.0,f:'198'}]},{c:[{v:'BD'},{v: > > 1.58665E8,f:'158665000'},{v:1045.0,f:'1045'}]},{c:[{v:'NG'},{v: > > 1.48093E8,f:'148093000'},{v:142.0,f:'142'}]},{c:[{v:'RU'},{v: > > 1.41933955E8,f:'141933955'},{v:8.4,f:'8.4'}]},{c:[{v:'JP'},{v: > > 1.2779E8,f:'127790000'},{v:339.0,f:'339'}]}]}" > > End Sub > > > Private Sub SendResponse(reqId as string, version as string, > > responseHandler as string, out as string, outFileName as string, > > status as string, warnings as string, errors as string, table as > > string) > > Dim sReturn as string > > > If responseHandler <> "" Then > > sReturn = responseHandler + "({" > > Else > > sReturn = "google.visualization.Query.setResponse({" > > End If > > If version <> "" Then > > sReturn += "version:'"+version+"'," > > End If > > If reqId <> "" Then > > sReturn += "reqId:'"+reqId+"'," > > End If > > If status <> "" Then > > sReturn += "status:'"+status+"'," > > End If > > If status = "warning" Then > > sReturn += "warnings:'"+warnings+"'," > > End If > > If status = "error" Then > > sReturn += "errors:'"+errors+"'," > > End If > > If sig <> "" Then > > sReturn += "sig:'"+sig+"'," > > End If > > If table <> "" Then > > sReturn += "table:"+table > > End If > > > sReturn += "});" > > > Response.Clear() > > Response.Write(sReturn) > > Response.Flush() > > Response.Close() > > Response.End() > > End Sub > > > Private Sub ParseTQX() > > Dim tqx as string() > > Dim name as string > > Dim value as string > > tqx = Request.QueryString("tqx").tostring.split(";") > > For Each item as string in tqx > > name = item.split(":")(0) > > value = item.split(":")(1) > > Select Case name > > Case "reqId" > > reqId = value > > Case "version" > > version = value > > Case "sig" > > sig = value > > Case "responseHandler" > > responseHandler = value > > Case "out" > > out = value > > Case "outFileName" > > outFileName = value > > End Select > > Next > > End Sub > > </script>- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. 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 -~----------~----~----~----~------~----~------~--~---
