leerickx

Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Author
    Replies
  • April 25, 2013 at 4:12 pm in reply to: multiselected field with data url don’t show me all values selected after an insert #100965
    leerickx
    Participant

    The problem was my request SQL. For those who would like:

    $SQL = “id, GROUP_CONCAT(cognitif.cognitif) AS cognitif FROM fiche

    INNER JOIN cognitif ON FIND_IN_SET (cognitif.idcognitif, fiche.idcognitif) > 0″

    .$where.” ORDER BY $sidx $sord LIMIT $start , $limit”;

    $result = mysql_query( $SQL ) or die(“Couldn?t execute query.”.mysql_error());

    Thank you again.

    April 23, 2013 at 5:34 pm in reply to: multiselected field with data url don’t show me all values selected after an insert #100962
    leerickx
    Participant

    tony said:

    Hello,

    I'm not sure I understand rigth the problem, but when you use form edition only one row can be posted to the server instead that you have more selected one.

    Only the delting rows support multiselect

    Regards

    Thanks Tony

    In fact, I have an “edit form” with several fields one of which is “EditType: 'select'” with in “editoptions: multiple true”.

    I get the values ​​with “dataURL 'ddlcognitif.php' in editoptions”.

    All is well in the insert when I choose two values​​, for example: memory, application. My db server side inserts data in 1,2. Correct.

    I wish that when I reopened my edit form I found in the box the items I had selected. But I see one of two or three, four … I had selected.

    Now if I use the widget multiselect and it seems to work well but when I reopened my edit form I see my field empty only the text from – noneSelectedText: “Any”,

    dataInit: function (elem) {

    setTimeout(function () {

    $(elem).multiselect({

    minWidth: 100, //'auto',

    height: “auto”,

    selectedList: 6,

    checkAllText: “all”,

    uncheckAllText: “no”,

    noneSelectedText: “Any”,

    open: function () {

    var $menu = $(“.ui-multiselect-menu:visible”);

    $menu.width(“auto”);

    return;

    }

    });

    }, 50);

    },

    I guess I have to do the opposite, but I don't see how.

    Another big thank you.

    March 17, 2013 at 7:59 pm in reply to: How to bind two detail grid with onselectRow #100830
    leerickx
    Participant

    Sorry, it was a stupid question.

    onSelectRow: function(ids) {

    if(ids == null) {

    ids=0;

    if(jQuery(“#fileupload_grid”).jqGrid('getGridParam','records') >0 )

    {

    jQuery(“#fileupload_grid”).jqGrid('setGridParam',{url:”fileupload_grid.php?q=2&id=”+ids,page:1});

    jQuery(“#fileupload_grid”).jqGrid('setCaption',”Fiche Projet ID: “+ids)

    .trigger('reloadGrid');

    }

    } else {

    jQuery(“#fileupload_grid”).jqGrid('setGridParam',{url:”fileupload_grid.php?q=2&id=”+ids,page:1});

    jQuery(“#fileupload_grid”).jqGrid('setCaption',”UPLOAD DE FICHIERS – Fiche Projet ID: “+ids)

    .trigger('reloadGrid');

    }

    if(ids == null) {

    ids=0;

    if(jQuery(“#datesup_grid”).jqGrid('getGridParam','records') >0 )

    {

    jQuery(“#datesup_grid”).jqGrid('setGridParam',{url:”datesup_grid.php?q=3&id=”+ids,page:1});

    jQuery(“#datesup_grid”).jqGrid('setCaption',”Fiche Projet ID: “+ids)

    .trigger('reloadGrid');

    }

    } else {

    jQuery(“#datesup_grid”).jqGrid('setGridParam',{url:”datesup_grid.php?q=3&id=”+ids,page:1});

    jQuery(“#datesup_grid”).jqGrid('setCaption',”DATES SUPPLEMENTAIRES – Fiche Projet ID: “+ids)

    .trigger('reloadGrid');

    }

    },

    March 11, 2013 at 4:45 pm in reply to: Master Detail Add data ok Problems with Edit and delete. #100801
    leerickx
    Participant

    Cool

    Sorry I had some trouble with my db…

    I delete the relation between my two tables and success.

    March 8, 2013 at 3:48 pm in reply to: Master Detail Add data ok Problems with Edit and delete. #100799
    leerickx
    Participant

    well,

    I tried to put in the parameter of Edit :

    beforeShowForm: function(fordid) {

    var mygriddetail = $('#list10_d');

    var did = mygrid.jqGrid('getGridParam','selrow');

    var celdid = mygrid.jqGrid('getCell', did, 'id');

    if (did != null) {

    jQuery(“#list10_d”).setGridParam({editurl:'addupdatedeldataFileUpload.php?q=2&id='+celdid});

    }

    else alert(“Vous n'avez s

  • Author
    Replies
Viewing 5 replies - 1 through 5 (of 5 total)

Stay connected with us in your favorite flavor!

Copyright 2014 TriRand LtdAll Rights ReservedRSS

Back to Top