check the result of a CFQUERY via CFIF statement

Question

I am having an issue with the sytnax on how to get a value from a database and then check that value in an if statement in ColdFusion

This is what I have so far:

<cfquery name="reserveCheck" datasource="RC">
            SELECT comp_type FROM partnerCompany WHERE comp_ID = "#COOKIE.RISOURCEUSRID#"
</cfquery>

<cfoutput>
    <cfif #reserveCheck# NEQ 4>
                <li><a href="http://mywebsite/gonow/index.cfm" title="Product Search" target="_blank">Product Search</a></li>
    </cfif> 
</cfoutput>

*having an issue with the sytnax* That is very ambiguous. What actually happens when you run the code? If you are getting an error, please [edit](http://stackoverflow.com/posts/25982028/edit) the question to include the full error message. — Leigh, Sep 22 '14 at 19:57

score 1 · Accepted Answer · answered Sep 22 '14 at 19:49

Change this:

<cfif #reserveCheck# NEQ 4>

to this

<cfif reserveCheck.comp_type NEQ 4>

This assumes your query only returns one row. If the query returns more than one row, the code in this answer only looks at the first row. That may or may not be what you want.

score 0 · Answer 2 · answered Sep 24 '14 at 04:33

You could modify your query so that it is not selected in the first place. Change your query to

<cfquery name="reserveCheck" datasource="RC">
    SELECT comp_type FROM partnerCompany 
    WHERE comp_ID = "#COOKIE.RISOURCEUSRID#"
    AND comp_type <> 4
</cfquery>

check the result of a CFQUERY via CFIF statement

2 Answers2