jQWidgets Forums

Forum Replies Created

Viewing 7 posts - 61 through 67 (of 67 total)
  • Author
    Posts
  • in reply to: date from mysql not correct date from mysql not correct #5915

    mr_putersmit
    Participant

    Peter

    Thanks for your help. Your suggestion in email worked fine. thanks

    in reply to: date from mysql not correct date from mysql not correct #5833

    mr_putersmit
    Participant

    Peter

    Nothing bounced back. I have resent now.

    Thanks

    in reply to: date from mysql not correct date from mysql not correct #5828

    mr_putersmit
    Participant

    Peter

    I have sent snapshot of problem to the supplied email address. Thanks

    in reply to: date from mysql not correct date from mysql not correct #5826

    mr_putersmit
    Participant

    Peter

    I have spent some time researching this problem and can report there is definitely something strange happening. I can display dates correctly if they are AM. However, if they are PM they do not display correctly. 2 Questions, do I need some kind of country (UK) file? Reason I ask is because in the globalization folder, there are en-CA and en-US, no UK file?

    Secondly, is there a chart showing dependencies of what file needs other file to work?

    Thanks

    in reply to: date from mysql not correct date from mysql not correct #5792

    mr_putersmit
    Participant

    Peter

    I am getting error: value.match is not a function which relates to

    var m = value.match(/^\/Date\((\d+)([-+]\d\d)(\d\d)\)\/$/);

    in firebug. What exactly would you like me to send you? Thanks

    in reply to: date from mysql not correct date from mysql not correct #5779

    mr_putersmit
    Participant

    Hi Peter

    It only seems to be happening to fields with a time entry. Entries with date display fine. I guess at entry level, what would be the correct markup to use to display a datetime field? Thanks

    in reply to: date from mysql not correct date from mysql not correct #5756

    mr_putersmit
    Participant

    hi P
    Thanks for reply. However, what I am trying to do is display a datetime field in then grid in the dd/mm/yyyy format. I have included a markup of what I am attempting to do, but obviously not working. Do I need to include the jqxdatetimeinput.js to display datetime field in the grid? Thanks

    $(document).ready(function () {
    // prepare the data
    var source =
    {
    datatype: "json",
    datafields: [
    { name: 'CompanyName'},
    { name: 'ContactName'},
    { name: 'ContactTitle'},
    { name: 'Address'},
    { name: 'City', type: 'date'},
    ],
    url: 'data.php'

    };

    var dataAdapter = new $.jqx.dataAdapter(source);

    $("#jqxgrid").jqxGrid(
    {
    source: source,
    theme: 'classic',
    width: 1200,
    altrows: true,
    enabletooltips: true,
    columns: [
    { text: 'Company Name', datafield: 'CompanyName', width: 250},
    { text: 'ContactName', datafield: 'ContactName', width: 150 },
    { text: 'Contact Title', datafield: 'ContactTitle', width: 180 },
    { text: 'Address', datafield: 'Address', width: 200 },
    { text: 'City', datafield: 'City', cellsformat: 'd', formatstring: "dd", width: 120
    }
    ]
    });
    });

Viewing 7 posts - 61 through 67 (of 67 total)