Chris Seymour
|
| Posted: 12/03/2002, 1:43 PM |
|
HI All,
What would cause the date fields from MySQL not to show in a grid? The
data is in the database, it just doesn't appear in the grid. They are
standard mySQL dates (yyyy-mm-dd format). Using PHP and Templates and CCS.
Any thoughts?
Thanks.
Chris
|
|
|
 |
Kasper Pedersen
|
| Posted: 12/04/2002, 8:04 AM |
|
Does it help to change the
Connection -> [Database name] -> Server -> DateFormat
to "yyyy-mm-dd HH:nn:ss" ?
If not - try setting the type to "text", to see if the problem originates
from the date formatting rutine.
Had some problems too earlier, but i cant seem to remember their origin ?!
Best regards
Kasper
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:92D9A23CFcseymourseywarecom@66.180.229.147...
> HI All,
> What would cause the date fields from MySQL not to show in a grid? The
> data is in the database, it just doesn't appear in the grid. They are
> standard mySQL dates (yyyy-mm-dd format). Using PHP and Templates and CCS.
>
> Any thoughts?
>
> Thanks.
>
> Chris
|
|
|
|
Dc.
|
| Posted: 12/06/2002, 10:53 AM |
|
Just change in your mysql database table date datatype to datetime if
possible.
After that everything works fine even without messing with types in css
(custom date format for example dd.mm.yyyy etc.)
"Chris Seymour" <cseymour@seyware.com> wrote in message
news:92D9A23CFcseymourseywarecom@66.180.229.147...
> HI All,
> What would cause the date fields from MySQL not to show in a grid? The
> data is in the database, it just doesn't appear in the grid. They are
> standard mySQL dates (yyyy-mm-dd format). Using PHP and Templates and CCS.
>
> Any thoughts?
>
> Thanks.
>
> Chris
|
|
|
|
|
