Ad:

MS SQL Discussion Thread
Unsolved
Views: 6822

Aug 24th, 2006

Problem With "Where" with boolean type

Expand Post »

Hi all,
Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped.

Here is the query

MS SQL Syntax (Toggle Plain Text)
SELECT * FROM MOTORS
WHERE     (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR
                      (CUSTOMERID = '62') OR
                      (CUSTOMERID = '72')
SELECT * FROM MOTORS
WHERE     (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR
                      (CUSTOMERID = '62') OR
                      (CUSTOMERID = '72')

This return 37 rows but there is two rows that have CHKCANCEL = 1

Any Ideas??

Thx

Last edited by blacklocist; Aug 24th, 2006 at 3:25 pm. Reason: Forgot select command in the example

Similar Threads

"Application uses Value of wrong type for the current operation" in Visual Basic 4 / 5 / 6
cannot get the sendmail to actualy send an email with the form selections in PHP
Pls Help vb $ excell “Couldn't find installable ISAM�? error. in Community Introductions
Have a problem with centering "jpg" files in HTML and CSS
"Problem in MultiThreading" in Java

blacklocist

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

87 posts
since Apr 2006

Permalink

Aug 24th, 2006

Re: Problem With "Where" with boolean type

I used this syntax and it work perfectly.

MS SQL Syntax (Toggle Plain Text)
 
USE MTRTRK
SELECT * FROM MOTORS
WHERE CUSTOMERID IN ('52', '72', '62') AND CHKCANCEL = '0' AND DITD IS NULL
use MTRTRK
SELECT * FROM MOTORS
WHERE CUSTOMERID in ('52', '72', '62') and CHKCANCEL = '0' and DITD IS NULL

blacklocist

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

87 posts
since Apr 2006

Permalink

Sep 12th, 2006

Re: Problem With "Where" with boolean type

the problem with you original query was precedence

what you need is

WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND( (CUSTOMERID = '52') OR
(CUSTOMERID = '62') OR
(CUSTOMERID = '72'))

campkev

Reputation Points: 14

Solved Threads: 19

Posting Pro in Training

Offline

484 posts
since Jul 2005

Permalink

Sep 13th, 2006

Re: Problem With "Where" with boolean type

Thanks I need to learn the importance of ( and )
THX!!

Click to Expand / Collapse Quote originally posted by campkev ...

the problem with you original query was precedence

what you need is

WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND( (CUSTOMERID = '52') OR
(CUSTOMERID = '62') OR
(CUSTOMERID = '72'))

blacklocist

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

87 posts
since Apr 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: SQL query

Next Thread in MS SQL Forum Timeline: Fulltext search with MS SQL

DaniWeb Message

Cancel Changes

User Name
Password