ASP SQL query for Null values not working

Posted on 2006-04-18
Last Modified: 2010-04-06
have a query that is returning no results although I know that there arecords that should be true.

Here is the query, also what would this query be for SQL database?

objRS.Open "SELECT DISTINCT cis FROM cmpnull WHERE cmpnull.OS = '" & strOS & "' AND cmpnull.cmpbldlbl isNULL",objConnection,3,3
Question by:tmurray22
    LVL 48

    Accepted Solution

    objRS.Open "SELECT DISTINCT cis FROM cmpnull WHERE cmpnull.OS = '" & strOS & "' AND cmpnull.cmpbldlbl is NULL",objConnection,3,3

    Author Comment

    Thanks, that worked, I read that the syntax in access was "isNull"

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Course: CSS Specialist

    We don’t have to sell you on the idea of becoming a developer. If you’re you here, you already know it’s one of the most lucrative (and fastest growing) career tracks out there. It’s CSS that allows you to set yourself apart from other web and mobile developers.

    Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System ( introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
    Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
    Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
    Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now