2 Replies Latest reply on Mar 19, 2009 6:29 AM by apocalipsis19

    cfsavecontent WEIRD situation

    apocalipsis19 Level 1
      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(getF ields.postalcode)#|#Trim(getFields.campaign)#|#DateFormat(getFields.firstordd,'MM/DD/YYYY' )#|#getFields.firstordamt#|#DateFormat(getFields.lastordd,'MM/DD/YYYY')#|#getFields.lastor damt#|#getFields.htdordcnt#|#getFields.htdordtot#|#getFields.annualordcnt#|#getFields.annu alordtot##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.