my bad, i didnt have the spreadsheet record set up for that page and i havnt yet figured out how to do error reporting for the query, thats next. here is where i will permanently host this gadget if anyone cares...
http://www.region3dfg.org/InformationManagement/CloudComputing/GadgetsPlusSpreadsheets/PageReportVersion1 if that isnt working try http://www.region3dfg.org/IM/CloudComputing/GadgetsPlusSpreadsheets/PageReportVersion1 On Nov 24, 5:02 pm, "Michael Geary" <[EMAIL PROTECTED]> wrote: > 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/reg... > > 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 -~----------~----~----~----~------~----~------~--~---
