Null Dates in AS400 [Archive]

GeoffAns

09-03-02, 16:06

I'm connecting an as400 dbase onto asp pages. It's no more different or difficult from sql, except for one thing, and I have scoured the net for answers.

In AS400 a null date value = 0001/01/01

On a SQL test I have 'error getting data' and in asp I get an error code 400 page.

Does anyone know how to pass a null date value through to server pages from the AS400??

GeoffAns

09-03-02, 16:26

I just wanted to expand on the question I've asked.

Firstly I only want the 00001/01/01 fields to be null.

The error i get back from my server page is;

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/indexes/CentralDetail.asp, line 342

line 342 is;
<%=(Central.Fields.Item("CP_DOB").Value)%>

Thanks in advance to anyone that can help me.