473,320 Members | 1,868 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SQL trouble with OR and AND

What I'd like to say with this SQL is this:

"I want all from mcContentBlocks where the type equals
$infoToBeSought1 and where the type doesn't contain "delete". I need
for either cbBelongsToWhichPage, or cbBelongsToMasterPage, or
cbBelongsToTopLevelMasterPage to equal $infoToBeSought2. All the
entries I want reside in one table. What is the correct way to say
this? I seem to be getting all kinds of trouble because of my use of
"OR".
$this->query = "SELECT * FROM mcContentBlocks WHERE
cbWhichType='$infoToBeSought1' AND cbWhichType NOT LIKE '%delete%' AND
cbBelongsToWhichPage=$infoToBeSought2 OR
cbBelongsToMasterPage=$infoToBeSought2 OR
cbBelongsToTopLevelMasterPage=$infoToBeSought2 OR AND
cbBelongsToWhichWebsite='$this->cbBelongsToWhichWebsite' ORDER BY
cbId";
Jul 17 '05 #1
2 1626
Try it with the parentheses I added and the extra 'OR' removed. I think
that's correct.

-Jay

lawrence wrote:
What I'd like to say with this SQL is this:

"I want all from mcContentBlocks where the type equals
$infoToBeSought1 and where the type doesn't contain "delete". I need
for either cbBelongsToWhichPage, or cbBelongsToMasterPage, or
cbBelongsToTopLevelMasterPage to equal $infoToBeSought2. All the
entries I want reside in one table. What is the correct way to say
this? I seem to be getting all kinds of trouble because of my use of
"OR".
$this->query = "SELECT * FROM mcContentBlocks WHERE
cbWhichType='$infoToBeSought1' AND cbWhichType NOT LIKE '%delete%' AND
(cbBelongsToWhichPage=$infoToBeSought2 OR
cbBelongsToMasterPage=$infoToBeSought2 OR
cbBelongsToTopLevelMasterPage=$infoToBeSought2)AND
cbBelongsToWhichWebsite='$this->cbBelongsToWhichWebsite' ORDER BY
cbId";


Jul 17 '05 #2
If complex SQL statements doesn't work, you should always try using paranthesis. Solve many such problems.

/M.
--
Martin Skjöldebrand
Family site: http://www.skjoldebrand.org
"Art" site: http://martoni.deviantart.com
Public key available at: http://wwwkeys.pgp.net
Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: James | last post by:
Hi I am having some trouble getting a asp page to load. Im a noob to the asp side. I have followed knowledege base Article 301305. I am running 2000 adv, IIS 5.0 I have the following...
4
by: Jacek Dziedzic | last post by:
Hi! First of all, I hope my problem is not too loosely tied to the "standard C++" that is the topic of this group. I have some code that exhibits a strange behaviour: on one computer, where I...
0
by: Paul C | last post by:
Hello, everybody. I am having trouble running some of the VS.NET samples, specifically the CarSelector web app, which is very simple. The symptom is that the web controls (drop down listboxes and...
0
by: Alexandre Jaquet | last post by:
Hi does anybody know how to solve my trouble, when I try to create a MS Office project I always got trouble. I can't create office project when I try to create one vs.net restart ... :s
2
by: Jeff | last post by:
/* -------------------------------------------------------------------------- Hello, I was experimenting with class templates and specializing member functions and came across a simple problem...
1
by: Jim Bancroft | last post by:
Hi everyone, I'm running into a problem with my ASP.Net application. I've just created a new aspx page which uses some new components of mine that inherit from ServicedComponent and are...
6
by: Daniel Walzenbach | last post by:
Hi, I have a web application which sometimes throws an “out of memory” exception. To get an idea what happens I traced some values using performance monitor and got the following values (for...
3
by: Olivier BESSON | last post by:
Hello, I have a web service of my own on a server (vb.net). I must declare it with SoapRpcMethod to be used with JAVA. This is a simple exemple method of my vb source : ...
2
by: JLupear | last post by:
I am having trouble with my code again, I had prepared a question and the code to upload, however I am having trouble posting it, are there limits to the amount of lines you can post? I split it...
0
by: mrchatgroup | last post by:
news from http://www.mrchat.net/myblog/myblog/small-accidents-mean-big-trouble-for-supercollider.html Small Accidents Mean Big Trouble for Supercollider Image Scientists expect startup...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.