>I'm just using a cfoutput querry loop.
>
>But I put in [CurrentRow] just in case. No change. Still not working.
Not sure if you're understanding fully, so I'll simplify completely:
(apologies if any of this is patronising)
This code here:
<cfoutput query="FAQ">
#Question#
</cfoutput>
Will do the same as this:
<cfoutput query="FAQ">
#FAQ.Question[FAQ.CurrentRow]#
</cfoutput>
If you did this:
<cfoutput query="FAQ">
<cfset Variables.Question = "X"/>
#FAQ.Question[FAQ.CurrentRow]#
</cfoutput>
You wouldn't be surprised that the output didn't change (I hope).
The following is IDENTICAL to ColdFusion as the above code:
<cfoutput query="FAQ">
<cfset Variables.Question = "X"/>
#Question#
</cfoutput>
And this code is also IDENTICAL to ColdFusion as both the above:
<cfoutput query="FAQ">
<cfset Question = "X"/>
#Question#
</cfoutput>
In other words, when you *set* the variable Question, it goes into the global
Variables scope.
However, when you *read* the variable Question, because you are looping through
the query, it looks first in the query's scope.
This is one of the reasons you find many people saying you should always scope
all variables - it avoids issues like this.
To make things work as you want, you need to either read the global Variables
scope, or instead to change the value within the query scope.
All make sense?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313753
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
