jQuery Grid Plugin - jqGridForum

Topic RSS

Conflit with id from recordset with Jqgrid id

18/11/2010
12:43

mario.arancione

Member

Members

Forum Posts: 3

Member Since:
18/11/2010

Offline

Hello all,

i've been searching if someone already had the problem but I didn't find...

I currently have a problem with Jqgrid.

I do an extraction data from a database:

Example

select id, firstname, lastname, from users; <-- id is the email so NOT a numeric key

If I give a recordset data from the above query to Jqgrid it's impossible to have a checkbox automatically checked on select row (standart behaviour of Jqgrid).

Instead if I don't select a field called "id" or more surprisingly if i select a numeric field called "id" it solves the problem..

We currently have a lot of db queries so that would be impossible to us to changed all of them..by removing id's fields.

That's the reason why i'm asking comunity's help in order to solve this problem by changing Jqgrid's behaviour.

Thank you

18/11/2010
13:38

mario.arancione

Member

Members

Forum Posts: 3

Member Since:
18/11/2010

Offline

It seems it can be a problem linked to addRowData method.

Example:

var myfirstrow = {invid:"1", invdate:"2007-10-01", note:"note", amount:"200.00", tax:"10.00", total:"210.00"};

jQuery("#myDiv").addRowData("not_numericID", myfirstrow);

I think it's what is happening (internally) if addRowData's first parameter (id) is not a numeric one there's a conflict and you cannot have a checked checkox on select row.

But how to fix it?

Because in my case i don't call explicitaly addRowData , i only give a recordSet to Jqgrid.

22/11/2010
12:38

mario.arancione

Member

Members

Forum Posts: 3

Member Since:
18/11/2010

Offline