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:332593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
