Thron, thanks very much for you very useful explanation.
Yes it is now clearer what you mean.
I will test your snippet and recommandation tomorrow and will tell you how
it works.
kind regards
Hansjoerg
2010/3/1 thron7 <thomas.herchenroe...@1und1.de>
> > I select the FileDate from MysQL DB and format it with MySQL function
> > DATE_FORMAT
> >
> > Select ...
> > DATE_FORMAT(B.FileDate, '%d.%m.%Y %k:%i:%s') AS FileDate
> > from table ..
> > ..
> > $recordset[] = array($color,$row['FileName'],$file_kb,$row['FileDate']
> );
> > ..
> > echo json_encode($recordset);
> >
> > Do you mean I have to "translate" the "FileDate" at data.php into a JS
> Date
> > format?
>
> Not quite. I was thinking of the client side where you receive the data:
>
> > var content = e.getContent();
> > if (content.length > 0) {
> > tableModel.setData(content);
> > }//if
>
>
> Right now you're just pushing the data that comes from the server right
> through to the table model. What I recommended was something like this
> instead:
>
> var content = e.getContent();
> var row;
> var dateFormat = new qx.util.format.DateFormat("dd.MM.yyyy HH:mm:ss");
> for (var i=0; i<content.length; i++) {
> row = [];
> row[0] = content[i][0];
> row[1] = content[i][1];
> row[2] = dateFormat.parse(content[i][2]);
> tableModel.addRows([row]);
> }
>
> You handle each data row and push it to the model individually. That
> gives you the opportunity to transform individual data items. My code
> snippet assumes that the $row['FileDate'] field sent from the server is
> actually a string, in the format as you listed in your initial mail.
>
> To turn that into a JS Date object I used a qooxdoo utility class,
> qx.util.format.DateFormat. I created an instance of this class, passing
> the expected string format, and then used it to parse the data coming
> from the server into a proper Date object (that's what e.g.
> dateFormat.parse("01.03.2010 10:49:22") would return).
>
> Of course, if you could return seconds-since-the-epoch from the server,
> that would be superfluous, and could be replaced by the much faster
> "row[2] = new Date(content[i][2]);". So there is maybe an optimization
> option in this aspect.
>
> Is that any clearer?
>
> T.
>
>
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> qooxdoo-devel mailing list
> qooxdoo-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
qooxdoo-devel mailing list
qooxdoo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
