You don't need the #'s either! change <cfset t1 = #Trim(t1.Team)#> to <cfset tname1 = Trim(t1.Team)> and <cfset logo1 = #Trim(t1.Logo)#> to <cfset logo1 = Trim(t1.Logo)>
thanks, eric cobb http://www.cfgears.com Maureen wrote: > You are using t1 as the name of a query: > <cfquery name="t1" datasource="hockey"> > > then you set it to a string > <cfset t1 = "#Trim(t1.Team)#"> > > then you try to use it again as a query name. > <cfset logo1 = "#Trim(t1.Logo)#"> > > Also, you don't need the quotes around the string on the right of the = sign > > change <cfset t1 = "#Trim(t1.Team)#"> to <cfset tname1 = #Trim(t1.Team)#> > and <cfset logo1 = "#Trim(t1.Logo)#"> to <cfset logo1 = #Trim(t1.Logo)#> > > On Mon, Apr 5, 2010 at 12:33 PM, Rick Sanders <c...@webenergy.ca> wrote: > >> This is the line throwing the error: >> >> <cfset logo1 = "#Trim(t1.Logo)#"> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm