CFset string concatenation (of query results)

Question

Is it possible to set a ColdFusion variable to a concatenated string?

<cfoutput query="getName">
   <cfset myName=#Firstname# #Lastname#>
</cfoutput>

Doesn't seem to work, nor does

<cfoutput query="getName">
   <cfset teacherName=#Firstname# + #Lastname#>
</cfoutput>

Answer 1

If you really need an additional variable, ColdFusion's concatenation operator is &

 <cfset teacherName = Firstname &" "& Lastname>

Though for simple output, no extra variable is needed. Just output the column values:

<cfoutput query="getName">
   #Firstname# #Lastname# <br>
</cfoutput>

Answer 2

As an alternative to using the ColdFusion & or &= string operators, you can also do the following:

<cfoutput query="getName">
    <cfset myName="#Firstname# #Lastname#">
    <p>#myName#</p>
</cfoutput>