jQuery UI Widgets Forums Grid Sending date time with Ajax

This topic contains 1 reply, has 2 voices, and was last updated by  Dimitar 9 years, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Sending date time with Ajax #60670

    daddetim
    Participant

    Hi all,
    i am using a basic configuration of jqxgrid. I have a date time field

    { text: \’DATA CRM\’, datafield: \’data_crm\’, columntype: \’datetimeinput\’, width: 100, cellsformat: \’d\’},

    I see in the cell the value in the format: “22/09/2014”

    but when i send the value of the raw via an ajax xhr i obtain in the server the extended format:
    “Wed Oct 22 2014 00:00:00 GMT 0200 (W. Europe Daylight Time)”

    How can i send only the date in the format: GG/MM/AAAA ? I need to put it in a mysql field DATE

    This is the Ajax section of the code:


    updaterow: function (rowid, rowdata, commit) {
    // synchronize with the server – send update command
    var data = “update=true&data_crm=” + rowdata.data_crm;
    $.ajax({
    dataType: \’json\’,
    url: \’asset.php\’,
    data: data,
    success: function (data, status, xhr) {
    if ( data == “1” ) {
    // update OK
    commit(true);
    });
    } else
    {
    alert(“Error”);
    };
    }
    }); `

    Thank you all
    bye

    Sending date time with Ajax #60699

    Dimitar
    Participant

    Hello daddetim,

    You can try the following change:

    var data = “update=true&data_crm=” + $.jqx.dataFormat.formatdate(rowdata.data_crm, "d");

    Best Regards,
    Dimitar

    jQWidgets team
    http://www.jqwidgets.com/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.