isNULL requires TWO arguments?

Results 1 to 2 of 2

Thread: isNULL requires TWO arguments?

  1. #1
    Join Date
    Dec 1969

    Default isNULL requires TWO arguments?

    I get his error when I trry ot use isNULL:<BR><BR>The isnull function requires 2 arguments. <BR><BR>my code:<BR>set rs= server.createobject("adodb.recordset")<BR>sql= "Select email from ECPVendor where isNULL(email)"<BR> sql, conn, 3<BR>count=rs.recordcount%&#062;

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: isNULL requires TWO arguments?

    yep<BR><BR>in SQL the isnull FUNCTION works differently R&D that<BR><BR>what you need is<BR><BR>"Select email from ECPVendor where email is null"<BR>

Posting Permissions

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