Thanks, I realized it after I saw I didn't have the cfoutput tags after the queries!
Rick -----Original Message----- From: Tony Bentley [mailto:[email protected]] Sent: Monday, April 05, 2010 4:34 PM To: cf-talk Subject: Re: java.lang.String as a structure with members 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:332607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
