CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge Studio -> IDE/GUI

 Application tolerant for different MySQL TIMESTAMP formats

Print topic Send  topic

Author Message
beckie

Posts: 16
Posted: 02/19/2005, 12:08 PM

I want to use the same CCS generated PHP application in different MySQL target environments. Some environments use MySQL , others version 4. And as of MySQL 4.1 the TIMESTAMP formate is changed (which is the format of ALL date/time fields in the entire database...).

Format:
- Before 4.1: yyyymmddHHnnss
- 4.1 and above: yyyy-mm-dd HH:nn:ss

Is it possible to have one generated CCS application that is tolerant for these different MySQL target environments?
View profile  Send private message
jojo1998
Posted: 04/20/2005, 12:30 PM

:-< :-< :-< :-< :-< :-< :-< :-X :-X :-X :-X :-X :-X :-X
Nicole

Posts: 586
Posted: 04/21/2005, 4:11 AM

Beckie,
You can create two .ccs project files with the same settings except database connection settings. Set different database date format in different project files. Use these files to generate and publish the project to different servers.

_________________
Regards,
Nicole
View profile  Send private message
beckie

Posts: 16
Posted: 04/21/2005, 4:16 AM

Thx. That's what I'm doing now.

I'd better contact the MySQL folks and ask them not to change the format of existing and critical field-types.
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.

PHP Reports

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

Home   |    Search   |    Members   |    Register   |    Login


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