[f150b0508]

Can someone help me find what I am doing wrong here? This should be simple but I am having a brain freeze.

I have a query like so:

<cfquery name="qchallenges" datasource="#Application.ds#">

SELECT * FROM newchallenges a
INNER JOIN team b on a.sentby = b.id

WHERE a.team_id = '#session.team.id#' AND a.expired = 'yes' OR a.declined = 'yes' OR a.accepted = 'yes'

</cfquery>

I have to pull results ONLY where the team_id matches the session.team.id, but also IF a.expired equals yes, a.declined equals yes, a.accepted equals yes among that team_id

I am having a problem with that stament pulling out information even if the team_id doesn't match. Example is it searches the database and found that the a.accepted field has a match so it shoes it even though the team_id doesn't match the session.team.id. I can't have that happening.

[CR250]

If any one of the OR's match it will be true. Change the OR's too AND

[SleepingInChapel]

It looks like an order of operations problem. Try this:

<cfquery name="qchallenges" datasource="#Application.ds#">

SELECT * FROM newchallenges a
INNER JOIN team b on a.sentby = b.id

WHERE a.team_id = '#session.team.id#' AND (a.expired = 'yes' OR a.declined = 'yes' OR a.accepted = 'yes')

</cfquery>

[f150b0508]

SleepingInChapel, on 12 Jan, 2009 - 01:15 PM, said:

It looks like an order of operations problem. Try this:

<cfquery name="qchallenges" datasource="#Application.ds#">

SELECT * FROM newchallenges a
INNER JOIN team b on a.sentby = b.id

WHERE a.team_id = '#session.team.id#' AND (a.expired = 'yes' OR a.declined = 'yes' OR a.accepted = 'yes')

</cfquery>

That did it! Thanks yet again!