Querying a specific sheet within a google spreadsheet not working.

[shumway]

Hello,

I am trying to query a specific sheet within a spreadsheet.
Unfortanetly it alwas takes the values of the sheet in position one. I
have tried setting the gid number to the sheet I want queried but it
still only queries the one in the first position. I also attempted to
use the &Sheet=SheetName parameter, but the result was also the same.
any help would be appreciated. Here is the code:

function onldQuery(){
var url='https://spreadsheets.google.com/a/finance-in-motion.com/tq?
key=0AjV_Fr31Owm1dDRXRGtIcUprZVRPbDM5Sl94dV9xRlE#gid=1';
var query = new google.visualization.Query('https://
spreadsheets.google.com/a/finance-in-motion.com/tq?
key=0AjV_Fr31Owm1dHJpVDVDYVNQM3pxVnBlUEtDR1RWb1E#gid=1');

query.send(handleOnldResponse);

}

[asgallant]

Use either the gid or sheet parameter, not both, and use a hash (#) instead of an ampersand (&), ie:

var query = new google.visualization.Query('https://spreadsheets.google.com/a/finance-in-motion.com/tq?key=0AjV_Fr31Owm1dHJpVDVDYVNQM3pxVnBlUEtDR1RWb1E#sheet=MySheetName');