<cfset t1 = "#Trim(t1.Team)#"> you're setting t1 equal to a string, so it's no longer a recordset.
cheers, barneyb On Mon, Apr 5, 2010 at 12:33 PM, Rick Sanders <[email protected]> wrote: > > I've done this a dozen times before, and now the following code gives me > this error: > > You have attempted to dereference a scalar variable of type class > java.lang.String as a structure with members. > > > > This is the line throwing the error: > > <cfset logo1 = "#Trim(t1.Logo)#"> > > > > The logo being pulled from the database is just the image name logo.jpg > > > > <cfquery name="Games" datasource="hockey"> > > SELECT Team1, Team2, GameDate, GameTime, Location, Comments FROM Games where > (GameID=#url.gameid#) > > </cfquery> > > <cfset team1 = #Games.Team1#> > > <cfquery name="t1" datasource="hockey"> > > SELECT Team,Logo FROM Teams WHERE (TeamID=#team1#) > > </cfquery> > > <cfset t1 = "#Trim(t1.Team)#"> > > <cfset logo1 = "#Trim(t1.Logo)#"> > > > > Thanks, > > > > Rick > > Webenergy > > www.webenergy.ca > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
