<Cfif> question

i must be really dumb.
i am checking against a query output to see whether a certain field is SOFT or INT

<cfoutput query="getD1">
<cfif getD1.Type IS 'SOFT'>
<cfset crap = 0>
<cfelse>
<cfset crap = 1>
</cfif>
#crap#<p></p>
</cfoutput>

for some reason, it always assigns crap as 1 even though there are several INTs in the output.
does anyone know why?

Falcon --

What do you get when you output #getD1.Type# that?

is your query set to get a certain record from the database or just a general number of records?

also i ran into some of the similar problems like you have there when i named the query, try using just type instead of getD1.type....

You could try using trim() around that, as any extra spaces that you don't notice would make the condition fail.

And this is a nice example of why not being thorough in your conditionals can cause big headaches. You may find this approach helps reduce problems like this:

<cfif getD1.Type IS 'SOFT'>
<cfset crap = 0>
<cfelseif getD1.Type IS 'INT'>
<cfset crap = 1>
<cfelse>
<cfset crap = "Neither condition was met!! Type is #getD1.Type#">
</cfif>
#crap#<p></p>

if i put
#type# -#crap#<p></p>
in that block. this is what i get

SOFT -1

SOFT -1

SOFT -1

INT -1

INT -1

SOFT -1

SOFT -1

SOFT -1

SOFT -1

SOFT -1

SOFT -1

INT -1

TRIM() solved the problem. damn.. thanks Kiteless and everyone