SQL query AND OR BETWEEN in same query

Question

0.00/5 (No votes)

See more:

C#

OleDbCommand cmd = new OleDbCommand("select * from Salary where GPFCPF=? AND  NameOfUnit=? AND GPFcategory=? AND SDATE BETWEEN @date1 and @date2 AND PoNo1 <> ? OR  PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ?  ORDER BY SlipNo ASC", con);

Hi everyone,
I am passing parameter to this code and why i am getting result only on the basis of other condition except SDATE BETWEEN @date1 and @date2.
please help me to find out error or give me some solution or idea.
thank you.

Posted 21-Jun-15 6:14am

varuncodee

Updated 21-Jun-15 6:56am

PIEBALDconsult

v2

Add a Solution

Comments

Michael_Davies 21-Jun-15 12:49pm

Please show the rest of the code, particularly the addparameters.

PIEBALDconsult 21-Jun-15 13:08pm

There is no need to see the rest of the code; only the SQL statement is required.

varuncodee 21-Jun-15 13:16pm

Sir i want to get result on the basis of date (SDATE BETWEEN @date1 and @date2)
other conditions are working fine expect date condition

PIEBALDconsult 21-Jun-15 12:58pm

You will often find that when using both AND and OR, you will need to use parentheses to specify your required precedence.
https://msdn.microsoft.com/en-us/library/ms190276.aspx

varuncodee 21-Jun-15 13:36pm

sir this code works, but i don't know why my previous query was not working, please tell me if you found what was the problem. thanks

 OleDbCommand cmd = new OleDbCommand("select * from Salary where (GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ) AND (SDATE BETWEEN @date1 and @date2) ORDER BY SlipNo ASC", con);

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

varuncodee · Answer 1 · 2015-06-21T07:35:00

Yipee! I solved it through your help friends

I modify my code like this

  OleDbCommand cmd = new OleDbCommand("select * from Salary where (GPFCPF=? AND  NameOfUnit=? AND GPFcategory=? AND PoNo1 <> ? OR  PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ) AND (SDATE BETWEEN @date1 and @date2) ORDER BY SlipNo ASC", con);

And it works.
Though i don't understand what was the problem with previous code in my question. if someone can tell me that would be very useful for future.
THanks to you Friends.

Lucifier Rocks · Answer 2 · 2015-07-03T19:38:00

OleDbCommand cmd = new OleDbCommand("select * from Salary where GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND (SDATE BETWEEN @date1 and @date2 )AND (PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ?) ORDER BY SlipNo ASC", con);

This would work as analyzer requires seperation of conditions for reading purpose

SQL query AND OR BETWEEN in same query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0