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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
