BUG: DHTML Databound Elements Ignore Regional Settings with RDS

• Microsoft Internet Explorer (Programming) versions 4.0, 4.01, 4.01 SP1, 4.01 SP2, 5.0
• Remote Data Service for ADO versions 1.0, 1.1, 1.5, 2.0, 2.01, 2.1, 2.1 SP1, 2.1 SP2

SYMPTOMS

When using Dynamic HTML (DHTML) databinding, elements databound to the RDS data source object do not appear with the proper regional settings on non-English installations of Windows. For example, the date January 20,1999, shows in the databound control with the format "1/20/1999," even on a German Windows NT machine that has the date format set to "20.01.99."

CAUSE

DHTML databinding delegates all type conversions and data formatting to the data source provider. RDS uses the standard OLE-DB type conversion library, which unfortunately ignores regional settings.

RESOLUTION

The only alternative is to databind procedurally to the datasource and do all the necessary type conversions programmatically. That is, script on the page needs to retrieve the Recordset directly from RDS, obtain the data, re-format it as desired, and then set that data into the proper page elements.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords          : kbDataBinding kbDHTML kbIE400bug kbIE401sp1bug kbIE401sp2bug kbGrpInet kbIE500bug kbDSupport 
Version           : WINDOWS:1.0,1.1,1.5,2.0,2.01,2.1,2.1 SP1,2.1 SP2,4.0,4.01,4.01 SP1,4.01 SP2,5.0
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: July 19, 1999