Hi Andrew Thanks that solved it. I wasn't referencing the row even though it was only a single row that was returned.
as in: <cfloop from="1" to="7" index="d"> <cfif program['discountValue' & d][1] is not "0"> <p><b>#program['discountReason' & d][1]#</b> value: $#program['discountValue' & d][1]#</p> </cfif> </cfloop> I appreciate all the help Rob On 14 Aug 2012 at 9:31, Andrew Scott wrote: > > And you will, if program is the name of the query then you need to > reference it with something like > > program[colName][Row] > > But that is if program is an actual query result set, which you > don't > mention if it is. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5892 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
