Your query assumes that there is only one row expected. What happens when you put the cfset inside of a cfoutput query tag? How many records are there? See my modified markup below.
><cfquery name="Games" datasource="hockey"> > >SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games where >(GameID=#url.gameid#) > ></cfquery> <cfoutput query="Games"> ><cfset team1 = #Games.Team1#> ><cfquery name="t1" datasource="hockey"> > >SELECT Team,Logo FROM Teams WHERE (TeamID=#team1#) > ></cfquery> <cfoutput query="Games"> ><cfset t1 = "#Trim(t1.Team)#"> > ><cfset logo1 = "#Trim(t1.Logo)#"> </cfoutput> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
