Focal Point
[CLOSED] Calendar control formats - POST data differs between servers

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1287012006

March 14, 2011, 09:27 AM
Wep5622
[CLOSED] Calendar control formats - POST data differs between servers
Hello all,

I'm having some difficulty with a calender control placed by HTML Composer. The control is a dynamic one, pointing straight to a master-file, which uses the format I8YYMD.

On my development environment, posting the form results in correctly formatted input data, according to I8YYMD (for example, 20110314). On our staging server however, I receive dates that appear to be formatted according to A10YYMD (for example, '2011/03/04').

Since I perform some numerical operations on the value, I get errors on the staging server. Not surprising, considering the difference in formats.

The question is, how can the format be different? They're exactly the same htm, fex and master-files, so the difference is probably caused by some external factor - but which factor could that be?!? What does the interpretation of a value in a calendar control depend on?

This message has been edited. Last edited by: Kerry,


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
March 14, 2011, 01:32 PM
<JG>
Obvious 1st question. same release on both platforms?

By that I include, WF Server, Client and java
March 15, 2011, 05:11 AM
Wep5622
How do we find out that information? The webconsole interface prints version-, or version-like, information in various places, but they seem to conflict each other.

I couldn't find any information more detailed than WebFOCUS server 7611 gen 403, which is the same on both servers. That seems to lack information about installed Hotfixes though. I got that info from the Help menu (odd place for version info...).

The JVM version number that WebFOCUS claims it's using (I dblclicked 'Java services' in the Workspace > Configuration menu) is 1.0.6_03 on both as well, but I know for a fact that I have 1.6.0_25 on my development server. Apparently those numbers aren't reliable?


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
March 15, 2011, 09:45 AM
Francis Mariani
Check the dbms version as well. Perhaps a date setting on one is different than the other.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 16, 2011, 05:13 AM
Wep5622
Unfortunately, both servers connect to the same DBMSes, so their versions are obviously the same as well.

I guess the solution is to check whether the incoming date in the fex is in the right format and hammer it into shape if it's not Sweating


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :