Yes you have it right, what Paul is maybe referring to is that it is considered extremely bad practice to use the * in queries.
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411<http://plus.google.com/108193156965451149543> On Tue, Aug 14, 2012 at 8:21 AM, Rob Voyle <[email protected]> wrote: > > * = all or have I got that wrong > Rob > > On 14 Aug 2012 at 8:09, Paul Kukiel wrote: > > > > > Thanks but what is the * > > > > You should ALWAYS individually select you column names. > > > > > > On 14/08/2012 8:04 AM, Rob Voyle wrote: > > > 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: > > 5886 > > 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:5888 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
