bradley baker
Top achievements
Rank 1
Rank 1
bradley baker
asked on 24 Aug 2009, 09:25 PM
Im trying to setup a grid with Hierarchy and a MySql database. I can get the connections setup fine and the initial tables loaded but I cant seem to get them to link. I get an error if I try to use the example with sessions or the
It just returns an error because in MySQL it has no idea what that means. Any ideas?
Basically I can get a full master list and then the linked details I get all the records in the table insted of just that users/customers because there is no "where" statment in the sql because thats the only way I could get it to work.
| (WHERE [FIELD] = ?) |
Basically I can get a full master list and then the linked details I get all the records in the table insted of just that users/customers because there is no "where" statment in the sql because thats the only way I could get it to work.
1 Answer, 1 is accepted
0
Hello Bradley ,
If I'm correct you cannot use square brackets with MySql SQL dialect, thus you may try removing them.
I have attached a simple demo page which demonstrates how to setup a hierarchical grid using MySql and Northwind database. Please take a look and let us know if I'm missing something obvious.
All the best,
Rosen
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
If I'm correct you cannot use square brackets with MySql SQL dialect, thus you may try removing them.
I have attached a simple demo page which demonstrates how to setup a hierarchical grid using MySql and Northwind database. Please take a look and let us know if I'm missing something obvious.
All the best,
Rosen
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.