Guriddo » Topic: Dropdowns bind to a “text” value instead of a key value….

Dropdowns bind to a “text” value instead of a key value….

Guriddo
Dropdowns bind to a “text” value instead of a key value….

This topic has 6 replies, 3 voices, and was last updated 17 years, 5 months ago by tony.

Creator

Topic
August 4, 2008 at 8:50 pm #71944

Jon
Participant

…. but post to the server as a key value.

Hi All,

When binding to a dropdown list my data has to contain the text of the dropdown versus the value of the dropdown.
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies
August 5, 2008 at 1:42 am #82973

tony
Keymaster

Jon,

What about keyvalue = text – I mean you can construct the dropdown to have the same values of key and text – If I understand right.

Regards

Tony

August 6, 2008 at 7:18 pm #82999

Jon
Participant

Hi Tony.

August 7, 2008 at 2:55 am #83002

tony
Keymaster

Hi Jon,

I think that I do not undertstand something. So let me explain what I know.

To the grid you send the text of the combo – right?

You use formedit to change the values of that field.

But before doing this jqGrid should know what for values and text are

for this combo – right? This is done via editoptions:{value:”key1:value1;…

In other words you should construct editoptions value. This can be

done statically and dynamically depending on your needs – or simply

we should have the key before they is sended to the server.

My question is where are the keys for these combos?

Best

Tony

August 7, 2008 at 5:15 am #83003

daniel.pool
Participant

Hello,

Sorry to butt in on a post, but I was about to request the same feature. My drop down lists uses the database ID of a field for the select's value and a text field as it's text. The fact that jGrid returns the value is great as I can simply put the ID into the referencing object. However, I'm having to fudge some nasty look up code (a problem with my companies framework) in order to provide the text value in the cell to resolve the drop down. It would be much easier for me to be able to use the ID and have the drop down resolve using that.

Regards,

~Dan

P.S. Your suggest to use the text and the value element of the select is not really feasible as some of the names can be very long and are not guaranteed to be unique.

August 7, 2008 at 5:27 am #83004

tony
Keymaster

This is true only if the values in editoptions are static. In case of dynamic values in options this will not work since the engine will read the data, but the text are not redy yet.

Instead I will try to investigate this

Thank you

Regards

Tony

August 7, 2008 at 10:27 am #83008

tony
Keymaster

Ok,

When the values are static here is a fragment on how to do that:

afterInsertRow : function(rowid,recdata){

var idtotext;

colid = 2; //the id of the column which holds the select begin from 0

switch (recdata.selectid){

case 'AB':

idtotext = 'ABTEXT';

break;

….

}

$(”#mygrid”).SetCell(rowid,colid,idtotext);

// when we use colid instead of colname this method is faster

}

Regards

Tony
Author

Replies