Replies Back to Article
Ajax DataGrid
Hi George and crew. Nice design on your extension Ajax DataGrid. Both the way the extension works in DW and also the output. But sadly to say. Unless there is someway to actually be able to alter the SQL to more advanced queries its rather useless for me and a waste of money. Very rarely do i only make use of one table in MySQL, but sometimes 2 or three. If its possible to do this somehow now or in a later 1.0.4+ update hurray!!!
Kind Regards
Sofus Comer, Denmark
Hi Sofus,
Thanks for your compliment! About more complicated queries it is actually no problem - you just need to define a VIEW from your complicated query in MySQL and then you can use the VIEW just like a simple table in the Ajax DataGrid!
Greetings,
George
Hi George and thanks for your quick reply.
I am happy to hear that. But i am kinda lost as to where this VIEW is defined on which code page?
Maybe you can give us an example to where we put the sql code. Maybe others will benefit from a small tutorial like that.
Kind Regards
Sofus
PHP
// SQL begins
// END of SQL
I am extremely happy with this extension. I am using one grid to drive another grid and my customer is over the moon about it. Many thanks DMXzone. May you all have a happy and peaceful Christmas!!
The only issues I have is that I cannot search each column in the grid directly from the column headers and I cannot compound-sort. Can this be possible??? Really similar to the way jQuery grids work.