DataTable Query and IE9

[Pegasusrjf]

It appears there may be an issue with using the DataTable query
options with IE9.

This page runs a 3 queries and two joins to create a table for
display.

http://www.northamericangp.com/event/Saturday/pages/ScheduledDrivers.html?4

Here is the error I get according to IE9 developer tool

SEC7112: Script from
http://spreadsheets.google.com/tq?pub=1&key=tFijkSiJElqcqvWczlkYGfA&headers=1&gid=1&tq=SELECT%20A%2CB%2CC%2CE%2CG%2CL%20WHERE%20C%3E1%20AND%20L%3C%3E%22A%22&tqx=reqId%3A0
was blocked due to mime type mismatch


I get this on all my visualizations that use queries to create a Data
table. The DataTable never gets created as the query never executes.

[Pegasusrjf]

Has anyone else seen this issue?

On Sep 16, 7:47 am, Pegasusrjf <pegasus...@gmail.com> wrote:
> It appears there may be an issue with using the DataTable query
> options withIE9.
>
> This page runs a 3 queries and two joins to create a table for
> display.
>

> http://www.northamericangp.com/event/Saturday/pages/ScheduledDrivers....

>
> Here is the error I get according toIE9developer tool
>

>   SEC7112: Script fromhttp://spreadsheets.google.com/tq?pub=1&key=tFijkSiJElqcqvWczlkYGfA&h...

[naven87]

I just read a blog on the IEBlog that described the problem and
solution, although I haven't tried to deal with it yet. So please
post back if you get a working solution on how well it worked.

http://blogs.msdn.com/b/ie/archive/2010/10/26/mime-handling-changes-in-internet-explorer.aspx

[Pegasusrjf]

> http://blogs.msdn.com/b/ie/archive/2010/10/26/mime-handling-changes-i...

Interesting.

Now I just need to figure out how to fix it. Not sure what I need to
change exactly in order to fix.

[Pegasusrjf]

Well, after reading through the blog post and reviewing all my web
pages I do have the script tag set to "text/javascript" The error is
appearing on the direct URL to connect to the spreadsheet itself.

I am not sure what I need to do in order to fix it at this point, but
i am obviously missing something.

[Pegasusrjf]

On Nov 4, 5:45 am, Pegasusrjf <pegasus...@gmail.com> wrote:
> Well, after reading through the blog post and reviewing all my web
> pages I do have the script tag set to "text/javascript"  The error is
> appearing on the direct URL to connect to the spreadsheet itself.
>
> I am not sure what I need to do in order to fix it at this point, but
> i am obviously missing something.
>

I have done more research, and the issue is the actual Query.send call
for the spreadsheet.

IE9 is seeing it as a mimetype of Text/plain, and not as script.
According to Fiddler this is where the error is occurring.

I have tried the different options (scriptInjenction, xhr, etc.) with
no resolution.

Not sure what else to try at this point.

[ChartMan]

Currently the standard data source implementation returns all scripts with mime-type "plain/text" which is failing for IE9. Thanks for reporting.

There is no easy fix at the moment unless you own the data source or you can use a non IE9 browser.

ChartMan

--
You received this message because you are subscribed to the Google Groups "Google Visualization API" group.
To post to this group, send email to google-visua...@googlegroups.com.
To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.

[Pegasusrjf]

Thank you for the reply. As the datasource is a google spreadsheet, I
have no fix at this time.

Is this something that may be reviewed and addressed before IE9
general release?

> > google-visualizati...@googlegroups.com<google-visualization-­api%2Bunsu...@googlegroups.com>
> > .

> > For more options, visit this group at

> >http://groups.google.com/group/google-visualization-api?hl=en.- Hide quoted text -
>
> - Show quoted text -

[ChartMan]

I will report this issue internally and we will work on preparing a fix.

Thanks in advance,

ChartMan

To unsubscribe from this group, send email to google-visualizati...@googlegroups.com.

[Pegasusrjf]

Do have any updated status on this issue?

 

Thank you.

[JasonCOL]

I am seeing the same problem with IE9 and mime type error message.

Jason

[Peter Wraae Marino]

wow,. this was posted 9/16/10 and this bug is still valid... what is going on.. how about somebody from google tells the status about this bug? why is it so hard to fix? is there a workaround?

I love using googles API, but this kind of bug can really make one reconsider. 

Peter

[Pegasusrjf]

It appears the issue has now been resolved as of someitme in the last
week.

I didn't even know until I was checking the defect report that I
submitted. Someone on the project answered on Saturday that it was
resolved, and when I tested it was.