DateTime MYSQL field showing blank

CodeCharge Studio

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

DateTime MYSQL field showing blank

Author

Message

asawyer13

Posts: 46

Posted: 06/26/2007, 3:26 PM

I have been out of CCS for a long time and just getting back in.
I am trying to create a report , but now I've also tried a grid, and I'm showing a field that is a mysql datetime field, but I get a blank field.
It could be something simple, but I can't see what I'm doing wrong.
Alan

mamboBROWN

Posts: 1713

Posted: 06/26/2007, 5:01 PM

asawyer13
Try these links out:
http://docs.codecharge.com/studio31/html/Components/Pro...oncept.html?toc
http://docs.codecharge.com/studio31/html/Components/Pro...DateFormat.html
http://docs.codecharge.com/studio31/html/Components/Pro...eField.html?toc

It basically sounds like you need to set the format for the properties FORMAT(how you wish the field to be displayed. ie yyyy-mm-dd) and DBFORMAT (which should be the format of the field as it is stored in the database).

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

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login