glemarie on JQgrid - Ondblclick event

Wed, 30 May 2012 11:09:08 +0300

Hi,

Are you sure that the rowid's are unique in the grid ?

naysilva on JQgrid - Ondblclick event

Tue, 29 May 2012 13:22:22 +0300

I am trying to use the OndblClickRow event to select the booking reference by which row is selected and no matter which row I select it always returns the first booking reference in the database. I'm not quite sure what I am doing wrong?

Here is my code:

    $("#bookings").jqGrid({
       url:'scripts/php/bootstrp/cp.request.php?ft=gg&table=bookings&showindex=1',
       datatype: 'xml',
       mtype: 'GET',
       colNames:['id','Booking Reference','Date of Booking','Time of Booking','Booking Date','Return Date', 'Fare'],
       colModel :[{name:'id', index:'id', hidden: true, editrules: { edithidden: true }},
            {name:'bookref', index:'bookref', align:'center', search:true, width:207},
           {name:'recordeddate', index:'recordeddate', align:'center', search:false, width:207},
           {name:'recordedtime', index:'recordedtime', align:'center', search:false, width:207},
            {name:'bookingdate', index:'bookingdate', hidden: true, editrules: { edithidden: true }},
            {name:'returndate', index:'returndate', hidden: true, editrules: { edithidden: true }},
           {name:'fare', index:'fare', align:'center', search:false, width:207}],
       pager: $('#bookingsPager'), rowNum:500, rowList:[500,2000,5000,10000],
       sortname: 'recordeddate',
       sortorder: "desc",
       viewrecords: true,
        hidegrid: false,
       imgpath: 'lib/themes/steel/images',
       height: '300px',
       forceFit: true,
       caption: 'Bookings History',
       loadtext: 'Loading',
       loadui:'enable',

        ondblClickRow: function(rowid)
       {
       var rowData = new Array();
           rowData = $("#bookings").getRowData(rowid);
           // rowBookingRef = rowData['bookref'];
           // getGridRow(rowData)
               // alert(rowBookingRef)
            $("#cp-bookings-dialog").dialog({ hide: 'slide', height: 625, width: 733, title: 'Booking Reference: - '+ rowData['bookref']});
       },

editurl: 'scripts/php/bootstrp/cp.request.php?ft=ug&table=bookings'
}).navGrid("#bookingsPager",{refresh:true,search:true,add:false,edit:false,del:false});

Could somebody let me know what I am doing wrong? This is giving me a massive headache.

jQuery Grid Plugin - jqGrid - Topic: JQgrid - Ondblclick event

glemarie on JQgrid - Ondblclick event

naysilva on JQgrid - Ondblclick event