probably simple cfoutput problem

[pixiesfb]

I set firstname and lastname. The first set of output tags gives me two sets of names, which is correct. The second set output tags only gives me one name. Why?


<cfquery name=&quot;GetInfo&quot; datasource=&quot;datasrc&quot;>
Select firstname, lastname
from prjoff_us
where (id in (8, 9))
</cfquery>

<cfoutput query=&quot;getInfo&quot;>
<cfset xfirstname= Trim(firstname)>
<cfset xlastname= Trim(lastname)>

#xfirstname# #xlastname#
</cfoutput>

<cfoutput>
#xfirstname# #xlastname#
</cfoutput>

 

[randall2nd]

This is because your first <cfoutput> has the attribute query=&quot;getInfo&quot;. If the query attribute is included, then everthing between the <cfoutput></cfoutput> tags is executed for each entry returned from the query. Your query &quot;getInfo&quot; must have returned two entries.

I am not very good at explaining things, but I hope this helps.

 

[khazmir]

I think randall2nd did a great job of explaining.

The reason you only get one set of names when you use just the <cfoutput> tag is because you aren't looping through a query. It's just outputting the last known values for #xfirstname# and #xlastname#. (Should be the second set of names from your <cfoutput query> tag.)