CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 MySql date & CCS ShortDate problem - 0000-00-00

Print topic Send  topic

Author Message
GeorgeS

Posts: 206
Posted: 01/16/2008, 1:14 PM

Hi,

Project Settings - Locales & Encodings - Date Display format
set to: ShortDate

MySql field type: date

Text box with pop-up calendar in Editable Grid -
Data Type: Date,
Format: ShortDate

All inserted / updated through the editable grid dates are showing up as 0000-00-00 in MySql
-------------------------------------------------------------------------------------------
What else should I set up and where?

Thank you
_________________
GeorgeS
View profile  Send private message
ckroon

Posts: 869
Posted: 01/16/2008, 2:08 PM

Look for the dbformat box at the bottom of the Properties-Data tab
it should be set to yyyy-mm-dd
:-D
_________________
Walter Kempees...you are dearly missed.
View profile  Send private message
GeorgeS

Posts: 206
Posted: 01/16/2008, 3:31 PM

Thanks!
I knew that I forgot something...
_________________
GeorgeS
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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