one gotcha is when cut and pasting code from this type of board. The quotes do not paste correctly so make sure after you paste the code you overwrite single and double quotes with the correct chars from your keyboard.

Some properties does not change (like width) if you change it dynamically.  But I think this should be.

Anyway I will look how can correct this.

Thank you

Regards

Tony

This does not work:

*********************

gridParams = JSON.stringify($(”#a_all”).getColProp());

*********************

So I have to do this

*********************

gridParams1 = JSON.stringify($(”#a_all”).getColProp(”id”));
gridParams2 = JSON.stringify($(”#a_all”).getColProp(”name”));
gridParams3 = JSON.stringify($(”#a_all”).getColProp(”date”));

*********************

Note too that I think there is a problem with the column widths not being updated.

I have a column name and if I look at the properties it shows:

*********************

{”name”:”name”,”index”:”name”,”width”:160,”editable”:true,”edittype”:”text”,”editoptions”:{”size”:”75″,”maxlength”:”250″},”resizable”:true}

*********************

That’s fine. Now if I use the hide/show column feature to remove this from the grid it shows:

*********************

{”name”:”name”,”index”:”name”,”width”:160,”editable”:true,”edittype”:”text”,”editoptions”:{”size”:”75″,”maxlength”:”250″},”resizable”:true,”hidden”:true}

*********************

That is fine too as it is correctly stating that the column is now hidden.

But if I show the column and adjust the width manually (by dragging the separator bar) then the change is not being shown. If I drag / shrink / expand the name column on screen the width is always showing as

*********************

“width”:160

*********************

Should not this change as I change the column width on screen?

*********************

loadComplete: function() {
jQuery('#a_all').setSelection('1');
gridParam = JSON.stringify($("#a_all").getGridParam());
alert(gridParam);
}

*********************

What that does is alert a huge text file of all the grid settings. Is it possible to just get the settings for the columns?

The documentation only shows selective options for

“url”
“sortname”
“sortorder”
“selrow”
“page”
“rowNum”
“datatype”
“records”
“selarrow”

Yes I'm just succesed with some new features. See roadmap.

Now I discover the problem with the pager. To resolve this

do not use

pager : jQuery("#mypager")

but just

pager : "mypager"

It will work.

For now you can use some like stringify function (just google it)

to convert the array to string.

Regards

Tony

In the meantime how can I save and load the grid parameters for just the columns?

I am using the setcolumns js which works great but the info is lost when the page is reloaded. I am also changing the column widths but this info is also lost on page reload.

what getgridparam do I need to use to get that info?

currently the documentation only shows:

“url”
“sortname”
“sortorder”
“selrow”
“page”
“rowNum”
“datatype”
“records”
“selarrow”

At end of next week I will publish roadmap.

One of the priority task is to configure the grid from xml

and/or json data - that is - there will be import and export methods 

Regards

Tony

I have a button which is used to save other stuff by passing variables to the php script:

******************

jQuery(”#a_today”).setGridParam({url:”/ajax/update_stuff.php?somestuff=”+somestuff,page:1}).trigger(”reloadGrid”);

******************

How can I pass the grid params to the server?

******************

var gridparams = $(’#a_today’).getGridParam();

jQuery(”#a_today”).setGridParam({url:”/ajax/update_stuff.php?somestuff=”+somestuff+’&gridparams=’+gridparams,page:1}).trigger(”reloadGrid”);

******************

The problem is that gridparam is an object - and it is huge. If I dump the object I can see that it is thousands of characters.

Can I compress / encode it and then uncompress / de-encode when to be used to retrieve grid settings?

Or should I just save only the properties I wish to be saved such as column names, widths etc. getgridparam(columns, widths….