Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Unanswered: Null Dates in AS400

    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??

  2. #2
    Join Date
    Sep 2002
    Posts
    2

    Re: Null Dates in AS400

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •