Forum


03:18

27/02/2010

Just downloaded the PHP libs and love them so far. A lot of success with most items but an issue when dealing with dates in columns.
I currently am running:
PHP 5.1.6
MySQL 5.0.77
(jQuery from google's site on each load as well)
It seems when I attempt to edit or add a date formatted column, things go a little strange.
For instance, changing the date to 2010-02-13 will cause the date field to uptdate to something completely random (2038-11-11). If I enter that date again, it occurs again but does not repeat the value – instead generating a new value. This leads me to believe it's not a formatting issue – rather another problem.
I have tried a series of changes:
- Change the format of the date column in the MySql DB (DATE,DATETIME,INT)
- Attempted omitting the formatter setcolproperty – or changing it
- Changed the srcformat and newformat to various types
This appears to occur with or without the datepicker add-in. I'm completely befuddled.
(This is in an edit dialog, not inline)
Anyone with any insight?
20:12

Moderators
30/10/2007

Hello,
Could you please post the issue in the appropriate forum here:
Also in the same forum there is a such solution.
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
Most Users Ever Online: 715
Currently Online:
79 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66