cfsavecontent WEIRD situation

[apocalipsis19]

Hi Community!

I have the following code:

<cfquery name="getFields" datasource="#application.dsn#">
select annualordcnt,annualordtot,campaign,email,firstname,firstordamt,firstordd,
htdordcnt,htdordtot,lastname,lastordamt,lastordd,postalcode
from yesmail
</cfquery>
<cfset test = 0/>
<!---<cfdump var="#getFields#"/><cfabort/>--->
<cfsavecontent variable="fileContent">
<cfloop query="getFields">
<!---<cfif #getFields.campaign[idx]# neq ''>
<cfset test = test + 1/>
</cfif>--->
<cfoutput> #Trim(getFields.email)#|#Trim(getFields.firstname)#|#Trim(getFields.lastname)#|#Trim(getFields.postalcode)#|#Trim(getFields.campaign)#|#DateFormat(getFields.firstordd,'MM/DD/YYYY')#|#getFields.firstordamt#|#DateFormat(getFields.lastordd,'MM/DD/YYYY')#|#getFields.lastordamt#|#getFields.htdordcnt#|#getFields.htdordtot#|#getFields.annualordcnt#|#getFields.annualordtot##Chr(13)##Chr(10)#
</cfoutput>
</cfloop>
</cfsavecontent>

I know that in the campaign field I have over 92,000 records different thatn space or null. However when I generate my export file there are only 21,000 campaign fields with data.

I am really confused on this one!

I'd appreciate any help!

Thanks!
Ysais.

[apocalipsis19]

<cfquery name="getFields" datasource="#application.dsn#">
select annualordcnt,annualordtot,campaign,email,firstname,firstordamt,firstordd,
htdordcnt,htdordtot,lastname,lastordamt,lastordd,postalcode
from yesmail
</cfquery>

That's the code ofrmy query that I missed at the top :-) Sorry!

[apocalipsis19 · Accepted solution]

I solved this issue!

Thanks to those who at least took the time to read my post!