RoyBaird
Posts: 115
|
| Posted: 08/19/2008, 1:35 PM |
|
I have a similar problem as I saw posted here with dates in CCS and mySql. I have changed all three atributes that relate to date: in the Settings and Property of the field. I have tried all combinations of yyyy-mm-dd. yyyy/mm/dd, shortdate. each time I only get 0000-00-00
Thanks,
_________________
Roy |
 |
 |
jjrjr1
Posts: 942
|
| Posted: 08/20/2008, 5:02 AM |
|
Hi Roy
On the properties for the date field in question, did you set the dbformat property?
In addition for the date format you must set the dbformat to the proper format the date is stored in the dtabase.
Let me know if that fixes your problem
Have fun
_________________
John Real - More CodeCharge Studio Support at - http://CCSElite.com |
|
|
|
RoyBaird
Posts: 115
|
| Posted: 08/20/2008, 5:57 AM |
|
That worked. I "know" I tried that yesterday... healed itself I guess!!! 
THANKS!!!
_________________
Roy |
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/20/2008, 9:18 AM |
|
Although that worked I still wonder......
In Project setting Connections, ServerTab you set Date Format exactly to the setup of you MySQL database, almost always yyyy-mm-dd HH:nn:ss.
In ProjectSetting Locales/Encodings you set the DateDisplayDefault
to the most general of choices, the one you expect to be using 80% of the time.
Optionaly, per language (Internationalization) you can override the formatting.
From then on, any 'date' field will offer formatting in it's properties as a dropdown, or allow custom formatting.
As far as I know, that is all there is to it.......
The DBFormat to be used only in exceptional cases.
Please prove me wrong?!
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
