What surprise me is that this would not work at all, not even the value of the first row. It actually throws an error:
<cfoutput>#colName#</cfoutput> I thought that query result variables do not require prefix if in a <cfoutput> loop, and query result variable is actually the first scope in the order of evaluation that coldfusion would look for. I guess <cfoutput></cfoutput> alone is not a loop. I guess you need the query attribute to make it a loop. Johnny >You had to use the query name in cfloop but not in cfoutput. > >That's the only rule there was... at least that I recall... > >so this worked: > ><cfoutput query="qryName">#colName#</cfoutput> > >And this worked: ><cfloop query="qryName">#qryName.colName#</cfloop> > >But this would only output the first row for every iteration: > ><cfloop query="qryName">#colName#</cfloop> > >Laterz, >J > > >On Sun, 27 Mar 2005 15:06:43 -0500, Andrew Tyrone <[EMAIL PROTECTED]> wrote: > > > >-- >Continuum Media Group LLC >Burnsville, MN 55337 >http://www.web-relevant.com >http://www.web-relevant.com/blogs/cfobjective ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200177 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
