RadGrid Filter Javascript Error

[lucky117]

Hi,

My field datatype is System.Decimal. When page culture is en-US, filtering is works but when page culture is tr-TR - decimalseperator is ',' (comma) - filtering is not working. I'm getting - ')' or operator expected - javascript error.

Why can this be, any suggestions?

[Konstantin Petkov]

Hi lucky117,

Indeed, we have to admit about this error appearing in RadGrid, but it has been already addressed. Please download the latest Q2 2008 version labeled 2008.2.723 from your Client.Net account and upgrade your project.

Should you need further assistance, please do let us know.

Greetings,
Konstantin Petkov
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Jeff]

I am having a similar issue.  If i put a single quote in the filter box i get a javascript error unterminated string constant.

The debugger never hits the 'RadGrid1_ItemCommand' or 'RadGrid1_Init1' events

[Vlad]

Hello Jeff,

This is fixed and the fix will be available with our Q3 release this week.

Regards,
Vlad
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[Kent]

I was having this problem using the RadGrid for ASP.NET AJAX Q3 2008.  But I fixed it by editing the column names in the stored procedure I call to populate the grid.  In Server Management Studio (using SQL Server 2005), I changed the  AS [Project Name] to  AS 'Project Name'.  Alternatively, [Project_Name] worked also.  Your mileage may vary.

Hope this was helpful.
Kent Stairley
Bent Oak Technologies, LLC

[kamakaze]

Hi,

I have a similar problem as the one described above. I have a GridTemplateColumn with DataType="System.Double". Inside it I have RadComboBox which gets the selected value from the datasource. However the filtering doesn't work with the fi-FI culture. It works with the us-US, but in the fi-FI when I put 7.5 for example I am getting

Invalid real literal '7.5' error. 
I am using 2008.3.1125.35 version.

Thanks 

[Pavel]

Hi kamakaze,

I tried to reproduce the error but with no success. You can find the sample website created for testing attached to this message. Try it and let me know if I am missing  something.

Sincerely yours,
Pavel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.

[kamakaze]

Hi,

I tested your grid, it worked. But I noticed that it is using the older telerik version 2008.3.1125.20. If I switch to the 2008.3.1125.35 (which I am using in my application) the filter on your grid stops working with doubles. So I will use in my application 2008.3.1125.20.

Thanks

[Wiktor]

Hello, Telerik!

As much as I hate to reply to 3 years old forum thread, I bumped into the same issue.
We have a pl-PL culture on our server and filtering double values with comma sign as a digital separator does not work. The error is the same as OP presented, but localized in Polish. Switching culture of the page to en-US fixes the issue, but is not an acceptable solution.

We are using Telerik AJAX 2011.2.915.35

Any help would be greatly appreciated.
Thanks,
Wiktor

[Johny]

Hi,

You said that your case work for "en-US" culture, but I bet that if you use "en-US" culture and try to filter by entering a value with comma separator you will get the same issue. You should ensure that your filter value contains decimal separator as per your culture. The best option would be to use a numeric column which filter control ensures this. You can also review this interesting thread that discusses acceptable values by the numeric text box:

http://www.telerik.com/community/forums/aspnet-ajax/input/radnumerictextbox-and-french-culture.aspx

Thanks,
Johny

[Wiktor]

Hi Johny,

thanks for reply and interest. AFAIK, the column in the grid was a numeric column. And during the tests we tried ed-US setting and comma delimited value - error was completely different, something more like "value incorrect".

I will have a look at the link you provided, thanks for that and if it doesn't help, will send a formal support ticket to telerik.

Thanks again,
Wiktor