Checking against a query with CFIF

Is your <cfif code in inside a loop or output query and inside the <table> </table> tags?

Something like this:
getDataQuery...

<table...>
<cfoutput query="getDataQuery">

<cfif getDataQuery.col eq 10001>
Orange
<cfelseif...>
Apple
</cfif>

</cfoutput>
</table>

Does that help?

Can you post all your code?

I often debug if/else logic like this:

<cfif somevariable is "some value>
true
<cfelse>
<cfdump var="#somevariable#">
<.cfif>

As I said, the values are int(11) in my table,
and I am basically using <cfif getNotes.process_id IS 10001>
and then setting a variable after that.
I narrowed it down and so there could only be one problem and thats my if statement...what else would you like?

cjdunkerley wrote:
> Have you thought about having another table to contain the
> values apple, orange, etc.?

That is probably the approach I would take. Either that or a CASE statement. Unless there is a specific reason the comparison must be done in CF.

Hi,

Have you thought about having another table to contain the values apple, orange, etc.?

You could then simply JOIN the tables on the ID column and your table will display the text withou having to use the <cfif's

I understand your goal, but I cannot really help without knowing more about the values.

Assuming you have eliminated bad data as a cause, it is possible CF is interpreting the values differently than you think. Since since CF is loosely typed it often applies some rather liberal rules with regards to interpretation and conversion of values. In short, while you may think you are comparing two simple numbers or two strings .. that may not be what is actually happening.

http://livedocs.adobe.com/coldfusion/7/htmldocs/00000909.htm

OK - There is more data in the table, etc...and it is a bit more complicated, but I did output a table and it works PERFECTLY displaying 10001, 10002, 10003. What I need to do is convert these values to "apple" "orange" or "pear" (or whatever) before I insert them into the table...
so i used a CFIF statement to do that, and then output it into the table using a seperate variable, like I said above...
so...

<cfif #getNotes.process_id# IS 10002>
<cfset fruit = "Orange">

<cfelseif #getNotes.process_id# IS 10001>
<cfset fruit = "Apple">

<cfelseif #getNotes.process_id# IS 10003>
<cfset fruit = "Pear">

</cfif>

And then:

<cftable query="getNotes" htmltable="yes" border="yes">
<cfcol text=#fruit#>
</cftable>


But it says that fruit couldnt be found....yet, I can display the ACTUAL values like so:

<cftable query="getNotes" htmltable="yes" border="yes">
<cfcol text=#getNotes.process_id#>
</cftable>

freedomflyer wrote:
> And it says "source" is undefined...

Yes, because there is no else case. But again, what is the actual value of getNotes.process_id that is failing? CFDump the query.

BTW, you know you could also do this in your database query using a CASE statement, right?

The column type is int(11)

I just whittled it down to
<cfif getNotes.process_id IS 10001>
<cfset source = "Orange">
</cfif>

And try to display it in a table:

<cftable query="getNotes" htmltable="yes" border="yes">
<cfcol text=#source#>
</cftable>

And it says "source" is undefined...

The column type is int(11)

I just whittled it down to
<cfif getNotes.process_id IS 10001>
<cfset source = "Orange">
</cfif>

And try to display it in a table:

<cftable query="getNotes" htmltable="yes" border="yes">
<cfcol text=#source#>
</cftable>

And it says "source" is undefined...