jQuery Forum

Hello,
#1)
colModel : [
{ name:ID, hidden:true, editable:true, editrules:{edithidden:true},
editoptions:{readonly:true} },
..
]
Look into the docs for more details.
#2) In wich browser is this?
#3) Currently not possible. It is hardcoded in the source. Will try to
put this in the css
in order to be customisable.
#4) Could youi plese the grid configuration and piece of data that is
populated
in the grid.
Regards
Tony

Hi Tony -
#1) thanks so much for the hint on the readonly field. I must have
missed that one in the documentation; works perfectly! Howover, the
row placement being the value of the "id" that is being sent is
obviously a problem as I can't use that to manipulate my database
records. Unfortunately, I can't change the field name in the database
which is named "ID" and I'm using VB.NET on the backend which isn't
case sensitive. So, I'm having a conflict between the "id" and the
"ID". But, I have ID defined like this in the colModel:
{ name: "ID", width: 3, hidden: true, key: true, sorttype: 'int',
editable: true, editrules: { searchhidden: true, index: 'ID', jsonmap:
'ID' }, editoptions: { readonly: true} }
I was thinking maybe I could just send this field as an extra
parameter or something. But, isn't the "key" attribute what should
make it the "id" ?
#2) I am using FF primarily, but am testing along in IE 6 and 7 as I
move forward. Yesterday, it was the "Add record" form that was always
popped open when I opened the page, but since then I added a show/hide
column window and now it's the one that's showing up on each page
request. I'm assuming it has something to do with the way I am trying
to implement the method. I just have it tacked on at the end, instead
of being inside an event. I guess I need to attach it to a click event
instead.
}).$("#searchFields").filterGrid("#mygrid", { gridModel: true,
gridNames: true, formtype: "vertical", enableSearch: true,
enableClear: true, autosearch: true });
#3) Sorry to hear about the column styling, but I'll be looking
forward to seeing your new features for that in the future.
#4) I have a large grid (about 165 lines) so I'm not sure how you
want me to send it. Do you want me to send all of the grid
configuration or just a piece of it? Here is an example of how I have
defined one column that needed a select list on the edit form:
{ name: "InterchangeVersion", width: 25, resizable: true, sortable:
true, sorttype: 'text', editable: true, edittype: 'select',
editoptions: { value: "004010X098A1:4010 Prof A1;004010X097A1:4010
Dental A1;004010X096A1:4010 Inst A1;004010X098A:4010 Prof;004010X097A:
4010 Dental;004010X096A:4010 Inst" }, editrules: { required: true,
index: 'InterchangeVersion', jsonmap: 'InterchangeVersion', label:
'InterchangeVersion', resizable: true, search: true} },
The value held in the database (and displayed in the grid) is the
value on the left of the colon. The text to show in the dropdown is
the right side. Is this correct?
#5 ) The other thing I was going to ask also is that on my pager, I
have 7 total records, but it shows 14. Yesterday it was doing the same
thing. I had the records per page set to 3 and there were a total of 5
records, but the pager showed 8. And, it always shows page 1 of 0. I
was using alert's after the json string was read and it alerts the
correct number of pages, so I was just curious what I may be doing
wrong there and what I could look for.
Thanks so much!!

Hi Tony -
#1) thanks so much for the hint on the readonly field. I must have
missed that one in the documentation; works perfectly! Howover, the
row placement being the value of the "id" that is being sent is
obviously a problem as I can't use that to manipulate my database
records. Unfortunately, I can't change the field name in the database
which is named "ID" and I'm using VB.NET on the backend which isn't
case sensitive. So, I'm having a conflict between the "id" and the
"ID". But, I have ID defined like this in the colModel:
{ name: "ID", width: 3, hidden: true, key: true, sorttype: 'int',
editable: true, editrules: { searchhidden: true, index: 'ID', jsonmap:
'ID' }, editoptions: { readonly: true} }
I was thinking maybe I could just send this field as an extra
parameter or something. But, isn't the "key" attribute what should
make it the "id" ?
#2) I am using FF primarily, but am testing along in IE 6 and 7 as I
move forward. Yesterday, it was the "Add record" form that was always
popped open when I opened the page, but since then I added a show/hide
column window and now it's the one that's showing up on each page
request. I'm assuming it has something to do with the way I am trying
to implement the method. I just have it tacked on at the end, instead
of being inside an event. I guess I need to attach it to a click event
instead.
}).$("#searchFields").filterGrid("#mygrid", { gridModel: true,
gridNames: true, formtype: "vertical", enableSearch: true,
enableClear: true, autosearch: true });
#3) Sorry to hear about the column styling, but I'll be looking
forward to seeing your new features for that in the future.
#4) I have a large grid (about 165 lines) so I'm not sure how you
want me to send it. Do you want me to send all of the grid
configuration or just a piece of it? Here is an example of how I have
defined one column that needed a select list on the edit form:
{ name: "InterchangeVersion", width: 25, resizable: true, sortable:
true, sorttype: 'text', editable: true, edittype: 'select',
editoptions: { value: "004010X098A1:4010 Prof A1;004010X097A1:4010
Dental A1;004010X096A1:4010 Inst A1;004010X098A:4010 Prof;004010X097A:
4010 Dental;004010X096A:4010 Inst" }, editrules: { required: true,
index: 'InterchangeVersion', jsonmap: 'InterchangeVersion', label:
'InterchangeVersion', resizable: true, search: true} },
The value held in the database (and displayed in the grid) is the
value on the left of the colon. The text to show in the dropdown is
the right side. Is this correct?
#5 ) The other thing I was going to ask also is that on my pager, I
have 7 total records, but it shows 14. Yesterday it was doing the same
thing. I had the records per page set to 3 and there were a total of 5
records, but the pager showed 8. And, it always shows page 1 of 0. I
was using alert's after the json string was read and it alerts the
correct number of pages, so I was just curious what I may be doing
wrong there and what I could look for.
Thanks so much!!

Hello,
#1) Yes you are right and I agree that the id should be configurable
from the developer.
This of course requiere a lot of work, but I think I will implemet
this.
#2) Check to see if you have loaded all the needed css and js files.
This is mostley caused that jqModal.css is not loaded.
#3) Definitley I will aplly this to the new 3.5 version.
#4) It is better to send me the configuration.
#5) Little stange. Which version do you use.
Also check your server response what you have in total records
Regards
Tony

HI Tony, now that you were able to show me how to make the (my) "ID"
field readonly, it is now being sent to the server like this: id:
(21,7) - Where 21 is my database key field and 7 is the row
placement. I can work with this because I can just parse it. BUT, the
delete method is still only sending the row placement. Is there a way
that I can add additional data to the parameters being sent with the
delete request?
Sorry if it's in the documentation and I've missed it. Believe me I
haven't closed this PDF file in days and I am pretty sure I've read
the whole thing a couple times over trying to learn everything for
this great tool.
Also, I have the jqModal.css file linked to the page, but maybe there
is something else missing. I checked in my grid configuration and I
have closeAfterAdd: true, closeAfterEdit: true, . . . but, it is not
closing after successful action. Does this solidify to you that this
is definitely a CSS issue??
Thanks again for the help!

Ok..had a brain cramp...I found the delete options..Alright!
Still having trouble with the jqModal forms though...but, things are
definitely moving forward and I'm excited. This is really an amazing
plug in Tony. Thanks so much for your contributions and ALL the help!
Briana