Rick, You can't use cfif within a cfset like that.
I think you cfsavecontent would be the best solution (best here being "most readable and maintainable). <cfsavecontent variable="Session.Client_Name"> #Get_New_Client.Client_First_Name# #Get_New_Client.Client_Middle_Name# #Get_New_Client.Client_Last_Name# <cfif Len(Trim(Get_New_Client.Client_Name_Suffix))> ,#Get_New_Client.Client_Name_Suffix# </cfif> </cfsavecontent> >My goal is to get rid of the comma after the Client_Last_Name, unless >there is a Client_Name_Suffix. > ><CFSET Session.Client_Name = > >'#Get_New_Client.Client_First_Name# >#Get_New_Client.Client_Middle_Name# >#Get_New_Client.Client_Last_Name# > ><CFIF Len(Trim(Get_New_Client.Client_Name_Suffix))> > >, #Get_New_Client.Client_Name_Suffix# > ></CFIF> > >'> > >This is all one line with no spaces, but I separated the parts >to make it easier to read.what am I doing wrong? > >Can I use the CFIF in the middle of the CFSET like that or should I do this: > ><CFSET Session.Client_Name= > >'#Get_New_Client.Client_First_Name# >#Get_New_Client.Client_Middle_Name# >#Get_New_Client.Client_Last_Name#' > ></CFSET> > ><CFIF Len(Trim(Get_New_Client.Client_Name_Suffix))> > ><CFSET Session.Client_Name='#Session.Client_Name#, >#Get_New_Client.Client_Name_Suffix#'> > >Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
