You should replace the -777 with a string "null", so that the output looks
like this:
[new Date(2013, 0, 18, 14, 0, 0), null, null, null, null, null]
Most browsers interpret ", ," as a null, but the last comma ",]" gets
ignored in most browsers (which is why you get that "Row given with size
different than 6" error) and causes IE to bomb.
On Tuesday, March 5, 2013 11:53:00 AM UTC-5, Matevz Uros Pavlic wrote:
>
> Hi,
>
> i've been working the whole day on finding out how to check if the values
> have -777 and replacing it with null value. I made that work (with help of
> asp.net forums)...BUT...there is a problem.
>
> I think we need to change that in Javascript, because if I change it in C#
> part, i can only change n-1 rows. For example, if i check and replace with
> nulls four out of four columns, the chart doesn't show, if i leave the last
> column not-null the chart shows. If i check the code in Console
> (shift+ctrl+j) i get the error :
> Uncaught Error: Row given with size different than 6 (the number of
> columns in the table).
>
> If i check Source the Array looks like this, when replaced with nulls :
>
> [new Date(2013, 0, 18, 14, 0, 0), , , , , ]
>
> And where values are not null, the array looks like that :
> [new Date(2013, 0, 18, 16, 0, 0), 268.14, 270.09, 270.55, 268.55, 259.3]
>
> It certainly has something to do with the last value when it is changed to
> NULL. I tried changing it to NULL also in SQL Server and importing such
> values. The result was the same.
>
> This is the code i used to replace the -777 values :
>
> {
> //Converts your object into a DateTime (so that it's
> properties can be accessed properly
> DateTime yourDate = Convert.ToDateTime(row["Datum"]);
>
> if (Convert.ToString(row["MPT11"]) == "-777")
> {row["MPT11"]= DBNull.Value;}
> if (Convert.ToString(row["MPT12"]) == "-777")
> {row["MPT12"]= DBNull.Value;}
> if (Convert.ToString(row["MPT2"]) == "-777")
> {row["MPT2"]= DBNull.Value;}
> if (Convert.ToString(row["MPT31"]) == "-777")
> {row["MPT31"]= DBNull.Value;}
> if (Convert.ToString(row["MPT32"]) == "-777")
> {row["MPT32"]= DBNull.Value;}
>
> rowsList.Add("[new Date(" + yourDate.Year + ", " +
> (yourDate.Month - 1) + ", " + yourDate.Day + ", " + yourDate.Hour + ", " +
> yourDate.Minute + ", " + yourDate.Second + "), "
> + row["MPT11"] + ", "
> + row["MPT12"] + ", "
> + row["MPT2"] + ", "
> + row["MPT31"] + ", "
> + row["MPT32"] + "]");
>
>
> Any ideas? could that also be because of regional settings (bTW , this is on
> local machine, not server).
>
>
> thanks, m
>
>
>
>
> On Tuesday, 5 March 2013 01:06:54 UTC+1, asgallant wrote:
>>
>> You would want to check before adding to the rowsList. It could also be
>> done in javascript, but it is probably easier to do in the server-side code.
>>
>> On Monday, March 4, 2013 4:04:45 PM UTC-5, Matevz Uros Pavlic wrote:
>>>
>>> What do you mean manually?
>>> I'd like to write a If sentence which would check if there is -777 and
>>> write null instead. But i don't understand where in my code should i do
>>> this, because i have a rowsList that adds all the rows in a Array.
>>>
>>>
>>>
>>> On Monday, 4 March 2013 21:53:38 UTC+1, asgallant wrote:
>>>>
>>>> Yes, you can use nulls in the chart, but you will have to translate
>>>> "-777" into null manually.
>>>>
>>>> On Monday, March 4, 2013 3:28:28 PM UTC-5, Matevz Uros Pavlic wrote:
>>>>>
>>>>> i have another problem regarding chart data. In SQL i have stored some
>>>>> null data, which are marked as -777. Is it possible to not use this data
>>>>> in
>>>>> charts and use NULL instead?
>>>>>
>>>>> On Monday, 4 March 2013 21:16:09 UTC+1, Matevz Uros Pavlic wrote:
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> the second option sounds way easier ;) . I'll check it out...
>>>>>> thanks
>>>>>>
>>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
