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:251066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
