CFIF Statement problems

[ford007]

I am trying to write a cfif statement, which shows a form only if the statemnt
acts true. It is a 3 part statement, the first two parts appear to work fine,
but the final part does not. I only want the statement to be true if the
Session.MM_Username is equal to the field task.allocation1. The code is as
below hopefully someone can help me please!??? Thanks in advance <cfif
(#task.completeown# EQ 1) AND (#task.completeass# EQ 0) AND
(#Session.MM_username# EQ #task.allocation1#)> <form method='post' name='form3'
action='<cfoutput>#CurrentPage#</cfoutput>'> <h5><font face='Arial, Helvetica,
sans-serif'> Click here to confirm task as complete:</font></h5> <table
align='center'><tr valign='baseline'><td nowrap align='right'>&amp;nbsp;</td>
<td><input type='submit' value='Task Complete'></td> </tr> </table> <input
type='hidden' name='MM_UpdateRecord' value='form3'> <input type='hidden'
name='tasknum' value='<cfoutput>#task.tasknum#</cfoutput>'> <input
type='hidden' name='completeass' value='1' <cfif (#task.completeass# EQ
1)>checked</cfif>> </form></cfif>:beer;

[jdeline]

First off, you can simplify your CFIF statement - see below. That probably
doesn't solve your problem, but it makes your code more readable.



<cfif task.completeown EQ 1 AND ask.completeass EQ 0 ANDSession.MM_username EQ
task.allocation1>

[Adam Cameron]

> First off, you can simplify your CFIF statement - see below. That probably

> doesn't solve your problem, but it makes your code more readable.
>
> <cfif task.completeown EQ 1 AND ask.completeass EQ 0 ANDSession.MM_username EQ
> task.allocation1>

And if task.completeown and ask.completeass are boolean values (ie: either
1 or 0), you can further clarify this as:

<cfif task.completeown AND NOT ask.completeass AND Session.MM_username EQ
task.allocation1>

But, back to the problem... you're finding that the Session.MM_username EQ
task.allocation1 expression is returning false? Hmmm. This kinda suggests
that they're not actually the same. You sure one of them doesn't have some
whitespace around the value you're not noticing?

It's also better to use compare() than EQ with strings, but it's not going
to help your situation; just food for thought.

Do this:

<cfoutput>
#task.completeown#<br />
#NOT ask.completeass#<br />
#Session.MM_username EQ task.allocation1#<br />
</cfoutput>

The should all be yes / not-zero / true.

Are they?

--

Adam

[ford007]

sorry bout the late reply, but i try not to work weekends. Err the answers to
the query you asked me to run came out as follows 1 Yes No So it is looking
as if you are correct, and my task.allocation1 and Session.MM_username are not
matching. I will have a look into this. Thanks for your help so far will let
you know how it goes, and if i run into further problems.

[OldCFer]

The following cannot work:
<cfif (#task.completeown# EQ 1) AND (#task.completeass# EQ 0) AND
(#Session.MM_username# EQ #task.allocation1#)>
...
<cfif (#task.completeass# EQ 1)>checked</cfif>>
</cfif>

In order to enter the first cfif block #task.completeass# must be 0. How can
it ever be 1 for the "check" value?
What does checking a hidden field do anyway?