I suspect the problem is that you need to create a sub array in each row of
the "row" array, like this:
var row = new Array();
for (var i = 0; i < numRows; i++) {
row[i] = new Array();
for (var j = 0; j < numCols; j++) {
row[i][j] = response.getDataTable().getValue(i, j);
}
}
On Friday, May 18, 2012 10:47:28 AM UTC-4, shumway wrote:
>
> Hello,
>
> I am trying to pull data from a google spreadsheet, put it into a
> multi-dim array, and then use the different elements of the array to
> populate drop boxes. I can't seem to get it to work correctly.
> Specifically the issue seems to lie with in this statement:
>
> var row = new Array();
> for (var i = 0; i < numRows; i++) {
>
> for (var j = 0; j < numCols; j++) {
>
> row[i][j] = response.getDataTable().getValue(i,j);
> // alert(response.getDataTable().getValue(i,j));
> }
> }
>
> Here is the full script:
>
> <html><head><title>1805</title>
>
> <script type="text/javascript" src="http://www.google.com/jsapi";></script>
> <script type="text/javascript">
> google.load('visualization', '1', {'packages':['table']});
>
> function onldQuery(){
> var
> url='https://spreadsheets.google.com/a/finance-in-motion.com/tq?tq=select
> A,B,C &key=XXXXXXXXXXXXXXXXXXXXXXXX';
> var query = new google.visualization.Query(url);
>
> query.send(handleOnldResponse);
> }
>
> function handleOnldResponse(response){
>
> if (response.isError()) {
> alert('Error in query: ' + response.getMessage() + ' ' +
> response.getDetailedMessage());
> return;
> }
> var data = response.getDataTable();
>
> var numRows = response.getDataTable().getNumberOfRows();
> var numCols = response.getDataTable().getNumberOfColumns();
>
> var row = new Array();
> for (var i = 0; i < numRows; i++) {
>
> for (var j = 0; j < numCols; j++) {
>
> row[i][j] = response.getDataTable().getValue(i,j);
> // alert(response.getDataTable().getValue(i,j));
> }
> }
> alert(row);
> var dd = document.getElementById("Username");
> var sb = document.getElementById("secondBox");
>
>
> for(var i = 0; i< row.length; i++){
>
> dd.innerHTML += '<option>'+row[i]+'</option>';
> sb.innerHTML += '<option>'+row[i][1] +'</option>';
> }
>
> }
>
>
> function queryGet(){
>
> var chose = document.getElementById('Username').value;
> var select = 'select A,B,C where A contains ' + chose;
> var url='https://spreadsheets.google.com/a/finance-in-motion.com/tq?tq=' +
> select + '&key=0AjV_Fr31Owm1dHJpVDVDYVNQM3pxVnBlUEtDR1RWb1E#gid=0';
> var query = new google.visualization.Query(url);
> query.send(handleQueryResponse);
>
>
> }
> function handleQueryResponse(response) {
> if (response.isError()) {
> alert('Error in query: ' + response.getMessage() + ' ' +
> response.getDetailedMessage());
> return;
> }
> var data = response.getDataTable();
> visualization = new
> google.visualization.Table(document.getElementById('queryDisplay'));
> visualization.draw(data, null);
> }
>
>
>
>
> // }
> </script>
> </head>
>
> <body onload="onldQuery()">
> <form>
>
>
>
> <select id="Username"></select>
> <select id="secondBox"></select>
>
>
>
>
>
>
> <input type="button" value="Submit" onclick="queryGet()" />
>
> </form>
> <div id="queryDisplay"></div>
> </body>
>
> </html>
>
--
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/-/Iu4ff7n5-MsJ.
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.
