Here is the query
<cfquery datasource="appreciativeway" name="program">
Select *
from programs
where programCode=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#prog#">
</cfquery>
On 14 Aug 2012 at 7:27, Paul Kukiel wrote:
>
> If program is a query it cannot be accessed that way. Can you show
> what that query looks like.
>
> On 14/08/2012, at 6:33 AM, "Rob Voyle" <[email protected]> wrote:
>
> >
> > Hi Folks
> >
> > I have a database that contains amongst others things 7 discount
> options and
> > values as separate fields (discountReason1, discountValue1,
> discountReason2,
> > discountValue2, etc. I created a query called program which works
> fine. However
> > I am trying to loop over the discounts and getting strange
> results.
> >
> > <cfloop from="1" to="7" index="d">
> > <cfif program['discountValue' & d] is not "0">
> > <p><b>#program['discountReason' & d]#</b> value:
> > $#program['discountValue' & d]#</p>
> > </cfif>
> > </cfloop>
> >
> > gives "Complex object types cannot be converted to simple values"
> error.
> >
> > Whereas:
> >
> > <cfloop from="1" to="7" index="d">
> > <cfif evaluate('program.discountValue' & d) is not "0">
> > <p><b>#evaluate('program.discountReason' & d)#</b> value:
> > $#evaluate('program.discountValue' & d)#</p>
> > </cfif>
> > </cfloop>
> >
> > Works just fine
> > What am I missing in the first example.
> > Thanks
> > Rob
> > Robert J. Voyle, Psy.D.
> > Director, Clergy Leadership Institute
> > For Coaching and Training in Appreciative Inquiry
> > Author: Restoring Hope: Appreciative Strategies
> > to Resolve Grief and Resentment
> > http://www.appreciativeway.com/
> > 503-647-2378 or 503-647-2382
> >
> >
> >
> >
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~|
> 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:
> 5884
> Subscription:
> http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
> Unsubscribe:
> http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:5885
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
