[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
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 :