I am working on something similar to that but i want to force excel export even if google is not available due to some reason. How do I include that check???
On Wed, Apr 15, 2009 at 11:40 PM, p00kie <[email protected]> wrote: > > So what about a rowCount * colCount < 10000 restraint? > > On Apr 15, 12:45 am, Murali krishna <[email protected]> wrote: > > If only number of rows is a constraint then we can go forward with this > > method but number of columns may also increase. For 10 columns the limit > may > > be 10000 but if he chooses 20 columns then limit will be somewhere > between > > 2000 to 3000 rows. If we can handle such type of exceptions then we can > > force an excel export. I even tried using paging feature with page size > of > > 100 rows but no use. > > > > Not only in this present situation, if in any case i get an error how do > i > > handle that in javascript. > > > > > > > > On Tue, Apr 14, 2009 at 11:17 PM, p00kie <[email protected]> wrote: > > > > > Murali, > > > > > An alternate solution to catch such exceptions would be to check the > > > row count. Unless you are hard-coding 10,000 data.addRow calls, I'm > > > assuming you have an external data source (eg. MySQL). I'm running in > > > a LAMP (P for Perl) environment and when I run the query, I make a > > > note of the number of rows returned. I then pass that to the > > > javascript portion of my code and depending on the number of rows, > > > I'll have the table showing or a message telling users to download the > > > data from an excel sheet. > > > > > if(rowCount <= 10000) { > > > <div id="table_div"></div> > > > } > > > else { > > > print p("Too many results returned"); > > > } > > > > > On Apr 14, 12:44 am, Murali krishna <[email protected]> wrote: > > > > Do we have an alternate solution to catch such exceptions and > redirect > > > users > > > > to download the data in form of excel sheets. > > > > > > On Tue, Apr 14, 2009 at 12:59 AM, VizGuy <[email protected]> wrote: > > > > > There is no actual limit on the data table size (when it is created > in > > > the > > > > > client. In a remote data source there is a limit of 10,000 > rows).Your > > > > > problem looks more like a browser limit of the string you are using > to > > > > > create it, or something similar. > > > > > > > Browser are not that strong animals when it comes to large js code > and > > > > > data, but they are getting better all the time... > > > > > > > Regards, > > > > > VizGuy > > > > > > > On Fri, Apr 10, 2009 at 12:15 PM, Murali <[email protected]> > wrote: > > > > > > >> I get the following error when i try to add about 5000 rows with > 15 > > > > >> columns > > > > > > >> Webpage Script Errors > > > > > > >> User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; > > > Trident/ > > > > >> 4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; > > > > >> InfoPath.2) > > > > >> Timestamp: Fri, 10 Apr 2009 09:09:29 UTC > > > > > > >> Message: Expected ')' > > > > >> Line: 28 > > > > >> Char: 157061 > > > > >> Code: 0 > > > > >> URI: > > > > >> > http://localhost:8080/nova/gvizReports.jsp?id=5510d6b3-3a9b-4354-972e. > > > .. > > > > > > >> The same code will run if i have less data. > > > > > > -- > > > > MK > > > > -- > > MK > > > -- MK --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
