locked
Order by NZ classic asp failed RRS feed

  • Question

  • User1154109855 posted

    Hi

    In Access i can send this query

    SELECT myDate
    FROM tblDate
    ORDER BY cdate(Nz([myDate],"01.01.2100"))

    If i try to select this query in classic asp it doesn't work. 
    "Undefined function 'Nz' in expression."

    Is there any workaround?

    thanks!

    Tuesday, November 7, 2017 4:25 PM

All replies

  • User-420868782 posted

    Hi gr8jr,

    "Undefined function 'Nz' in expression."

    As far as I know, the Nz function lets us return a value when a variant is null in Access application, if you want an alternative to the Nz function in classic asp, you can try to use an IIF(IsNull()) construct.

    With Regards,

    Fei Han

    Wednesday, November 8, 2017 2:43 AM