Now, i use a request in JavaScript to select a column with a condition
using "where",
but it doesn't work when i draw the result on my page iGoogle, i get
"error in query".
The strange thing is : when i do only : query.setQuery('select *'); it
works
but when i do : query.setQuery('select * where test <=25'); it doesn't
work
My spreadsheet already exists : i have a column "town" with NY,
Boston, etc. and i have a column "test" with 5,6,25,3,15,7, etc..
Maybe i need to specify that column "test" is a number ?
<![CDATA[
<script type="text/javascript" src="http://www.google.com/jsapi";></
script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["table"]});
google.setOnLoadCallback(initialize);
function initialize() {
// The URL here is the URL of the spreadsheet.
// This is where the data is.
var query = new google.visualization.Query("http://
spreadsheets.google.com/ccc?key=.............");
query.setQuery('select * where test <=25');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert("Error in query")
}
var ticketsData = response.getDataTable();
var table = new google.visualization.Table
(document.getElementById('patternformat_div'));
table.draw(ticketsData, {allowHtml: true, showRowNumber:
true});
}
</script>
<div id="patternformat_div"></div>
]]>
On 20 nov, 22:30, VizGuy <[EMAIL PROTECTED]> wrote:
> Unfortunately, if you want to use the gadget on top of Google Spreadsheets
> page, you can only use ranges, and there is no way to ignore col B.
> A few things you can do:
> 1. You can create another sheet in the same spreadsheet, with formulas that
> only take the relevant cols from the other sheet, and use the chart on this
> data.
> 2. If you want to display the chart on other places, and not on the
> spreadsheet (but still read the data from the spreadsheet), you can publish
> it to your iGoogle page (or anyother), and there you can append to the data
> source url, a parameter called tq in which you can specify data
> manipulations.
> Seehttp://code.google.com/apis/visualization/documentation/querylanguage...
> more details.
> In your case it will be like adding to the url: *&tq=select A,C*
>
> VizGuy
>
> On Thu, Nov 20, 2008 at 10:27 PM, Pragan <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > How to just display A1 and C1? If I try doing it with a comma or &, it
> > doesnt work.
> > I am trying to do this to show something like this
> > A B C
> > 1 pragan learn api
> > 2 Pragan check google
> > 3
> > So I want to just output
> > pragan api
> > Pragan google
> > by leaving the value in col B. I guess we cannot define range in this
> > case. Please let me know.
>
> > thanks
> > On Nov 20, 8:11 am, VizGuy <[EMAIL PROTECTED]> wrote:
> > > In the data source url, when it points to a Google Stpreadsheets page,
> > you
> > > can specify the sheet and the range as a apart of the URL:The range
> > > parameter in the format of A1:B5 can limit the selected range, and the
> > sheet
> > > can be set by a parameter sheet=<sheetName>
>
> > > So the entire url will be something like:
> >http://spreadsheets.google.com/tq/key=12345&sheet=Sheet1&range=A1:B2
>
> > > VizGuy
>
> > > On Wed, Nov 19, 2008 at 5:45 PM, Mathieu <[EMAIL PROTECTED]>
> > wrote:
>
> > > > Hello,
>
> > > > I have a spreadsheet on "Google Documents" with a sheet1, a
> > > > sheet2, ...
>
> > > > 2 things :
>
> > > > - I want to select a sheet of my spreadsheet using JavaScript
> > > > functions, is it possible ?
> > > > - After that, i want to select a column of this sheet, and draw only
> > > > this one on my iGoogle page, is it possible ?
>
> > > > I did that :
>
> > ---------------------------------------------------------------------------------------------------
> > > > function initialize() {
> > > > // The URL here is the URL of the spreadsheet.
> > > > // This is where the data is.
> > > > var query = new google.visualization.Query([EMAIL PROTECTED]);
> > > > query.send(draw);
> > > > }
>
> > > > function draw(response) {
> > > > if (response.isError()) {
> > > > alert("Error in query")
> > > > }
> > > > var ticketsData = response.getDataTable();
> > > > var table = new google.visualization.Table
> > > > (document.getElementById('table_div')),
>
> > > > // HERE I WANT TO SELECT A SHEET i.e "sheet1"..
> > > > // AFTER I WANT TO SELECT AND DRAW A COLUMN OF THIS SHEET, i.e
> > > > "adress"
>
> > > > table.draw(ticketsData, {allowHtml: true, showRowNumber:
> > > > true});
>
> > > > }
>
> > ---------------------------------------------------------------------------------------------------
>
> > > > Thanks by advance,
>
> > > > Mat
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
