10 Replies Latest reply on Sep 3, 2017 11:53 AM by TroyAllenSr

    CFMAIL Stripping Spaces in Release 2016

    charlesp36266952 Level 1

      We recently upgraded to ColdFusion 2016 having run ColdFusion for over a decade.  Most everything has gone well except a weird issue with email.  Every CFMAIL function now strips out spaces when displaying multiple variables in a row. 

       

      For example, many automated reports that generated output through CFMAIL have something like this in the code:

       

      Example Query:

       

      <cfquery name="GetUsers" datasource="database">

           Select User_Name_F, User_Name_L

           From Users

           Where Active = 1

           Order By User_Name_L, User_Name_F

      </cfquery>

       

      Output Code (in body of CFMAIL tag):

       

      <cfoutput>#GetUsers.User_Name_F# #GetUsers.User_Name_L#</cfoutput>

       

      Output Result (in multiple email clients):

       

      JohnDoe

       

       

      Before the upgrade this displayed as "John Doe" correctly with the space between names and has for years.  I can force a blank space by hard-coding it in, which I shouldn't have to do.  I can also do a "Select (User_Name_F + ' ' + User_Name_L) as name" and make it work, but many times I will use the first and last names in different orders in the same output, so I shouldn't have to do this either.  The same issue occurs from queries from MySQL 5 and Microsoft SQL Server.  The same issue occurs with variables from queries as well as variables created using CFSET. 

       

      Is this a bug?  What am I missing?

       

      Thanks!