Ian Skinner wrote: > IIRC CF is going to automatically scope to the nearest query. To > override this you will need to fully scope the variable.
when I tried scoping it using getRosters.ENTITYID, it *ALWAYS* returned the same entity id - the first one. It only works if I assign it to a different variable. The solution was given in an earlier post. To use the complete, fully qualified query scope, which is queryName.columname[rowNumber]. So this "fob bar #getRoster.EntityID[currentRow]#" should get what you want. It is important to note that using <cfoutput query=...> and <cfloop query=...> are just short cuts to the full query scope. This allows one to usually just access the data by column name. When one goes beyond the basics though, falling back to the full scoping will usually resolve the issue. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA --------- | 1 | | --------- Binary Soduko | | | --------- "C code. C code run. Run code run. Please!" - Cynthia Dunning ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233149 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
