CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> Archive -> GotoCode Archive

 Dates don't work (for me) CCS2 PHP MySQL Linux

Print topic Send  topic

Author Message
Posted: 11/19/2003, 1:30 PM

Column type in MySQL DB is DATE, Data Type in CCS2 is Date, Format in CCS2 is ShortDate. Every form I use has a date, at least "entrydate". I set the default value on each form to CurrentDate. When form is submitted all fields update database except any of my dates. Doesn't matter if I type them in, or datepick them or set them as defaults. I don't get it. Is it a MySQL setting??Suggestions?
Steve Ebbrell
Posted: 11/19/2003, 1:52 PM

Check the CCS Connections DATE FORMAT property, this is the format that the database stores on disk, for MySQL it should be one of the yyyy-mm-dd format options. All your forms and project settings should be the date format you want users to see, ccs will then convert them to and from the MySQL required yyyy-mm-dd format automatically.


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.