Your two query.setQuery() calls are identical other than the string passed
in:
> // query.setQuery('where B = "1802-2005-020-3"');
> query.setQuery('where B = "' + recid + '"');
If one works and the other doesn't, there must be a difference between the
two strings. It can't be an API issue if one of the two works.
What does the following code tell you?
var url1 = 'where B = "1802-2005-020-3"';
var url2 = 'where B = "' + recid + '"';
alert( url1 === url2 );
-Mike
> From: Region 3 DFG
>
> yeah i have done the alert window to check the value and an
> HTML in page method, but they look the same. ill post in the
> visualization api group now since this is specific to thier
> api. iif someone thinks of something go ahead and post here
> and i will check back.
>
> Thanks allot Michael and Jerome you were both a big help!
>
>
>
> On Nov 24, 2:46 pm, "Michael Geary" <[EMAIL PROTECTED]> wrote:
> > > // query.setQuery('where B = "1802-2005-020-3"');
> > > query.setQuery('where B = "' + recid + '"');
> >
> > You have two statements that in theory should both work the
> same - and
> > the first one does work, correct? Then all you need to find out is
> > what is different between them. Did you verify the second
> one with an
> > alert or console.log?
> >
> > alert('where B = "' + recid + '"');
> >
> > -Mike
> >
> > > From: Region 3 DFG
> >
> > > elegant, i can go for that. my query is still failing (at least i
> > > think thats whats going on) i add gadget to the page and
> the little
> > > spinning thing just keeps going and going.
> >
> > > var recid = document.referrer.split('/').pop();
> > > var myQuery = ('where B = "' + recid + '"');
> >
> > > function sendQuery() {
> > > var prefs = new _IG_Prefs(); // User preferences
> > > gadgetHelper = new google.visualization.GadgetHelper();
> > > var query = new google.visualization.Query('http://
> > > spreadsheets.google.com/tq?key=pSl3RWm2up8QW3MIs7lwDOA&pub=1');
> > > // query.setQuery('where B = "1802-2005-020-3"'); //hardcoded
> > > query for testing that works fine
> > > query.setQuery('where B = "' + recid + '"');
> > > query.send(handleQueryResponse);
> > > }
> >
> > > here is my current production version..
> >
>http://hosting.gmodules.com/ig/gadgets/file/110038818703520461296/reg3_spre
adsheet_row-report_habcon.xml
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"iGoogle Developer Forum" 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-Gadgets-API?hl=en
-~----------~----~----~----~------~----~------~--~---
