?
Solved

ASP SQL query for Null values not working

Posted on 2006-04-18
2
Medium Priority
?
169 Views
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
0
Comment
Question by:tmurray22
2 Comments
 
LVL 54

Accepted Solution

by:
Ryan Chong earned 2000 total points
ID: 16480057
objRS.Open "SELECT DISTINCT cis FROM cmpnull WHERE cmpnull.OS = '" & strOS & "' AND cmpnull.cmpbldlbl is NULL",objConnection,3,3
0
 

Author Comment

by:tmurray22
ID: 16489416
Thanks, that worked, I read that the syntax in access was "isNull"
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface In the first article: A Better Website Login System (http://www.experts-exchange.com/A_2902.html) I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
It's sometimes a bit tricky to use date functions in Oracle BPEL. I'll explain quickly how you can add N days to the current date. In a BPEL process this can be useful, and you can adapt it to fit your needs. First of all, let's see how to add 1 …
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
Suggested Courses

850 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