Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

outputing one file to a file at a time.

Hello, I'm trying to print of of each line from a query that I am doing into a file but the problem that I am having is that it keeps giving me one of a line multiple times. I tried using a comparision to see if I could set a standard for when to not copy but I'm not to familiar with how the cfloop works. Can someone help me with this. Here is my code for the printing part:

<!-- Display Data -->
<cfif isDefined("submit")>
      <cfif #qry_vendor.recordCount# eq "0">
            <h3>No records found matching your criteria.</h3>
            <cfabort>
      </cfif>
      
<table border = "0">
      <tr><td height = "15"></td></tr>
      
      <!-- Data Headers -->
      <tr>      
            <td nowrap style="font-size:8pt"><strong>Vendor Code</strong></td>
            <td nowrap style="font-size:8pt"><strong>Vendor Name</strong></td>
            <td nowrap style="font-size:8pt"><strong>Address</strong></td>
            <td nowrap style="font-size:8pt"><strong>State</strong></td>
            <td nowrap style="font-size:8pt"><strong>City</strong></td>
            <td nowrap style="font-size:8pt"><strong>Country Code</strong></td>
            <td nowrap style="font-size:8pt"><strong>Postal Code</strong></td>
            <td nowrap style="font-size:8pt"><strong>Phone</strong></td>
            <td nowrap style="font-size:8pt"><strong>Tax ID Number</strong></td>
            <td nowrap style="font-size:8pt"><strong>Tax Code</strong></td>
            <td nowrap style="font-size:8pt"><strong>Expense Acct</strong></td>
      </tr>

      <!-- Loop through the Data -->

      <cfset lven = "">
      <cfloop query = "qry_vendor">
      <tr>
                  <cfset cven = 'vendor_code'>
                  <td nowrap style="font-size:8pt">#vendor_code#</td>
                  <td nowrap style="font-size:8pt">#address_name#</td>
                  <td nowrap style="font-size:8pt">#addr1# #addr2# #addr3#</td>
                  <td nowrap style="font-size:8pt">#state#</td>
                  <td nowrap style="font-size:8pt">#city#</td>
                  <td nowrap style="font-size:8pt">#country_code#</td>
                  <td nowrap style="font-size:8pt">#postal_code#</td>
                  <td nowrap style="font-size:8pt">#contact_phone#</td>
                  <td nowrap style="font-size:8pt">#tax_id_num#</td>
                  <td nowrap style="font-size:8pt">#tax_code#</td>
                  <td nowrap style="font-size:8pt">#exp_acct_code#</td>
      </tr>
                  <cfif store_output eq "Yes" and lven NEQ vendor_code >
                        <cfset record = record & vendor_code & delimiter>
                        <!---- <cfset record = record & address_name & delimiter>      
                        <cfset record = record & addr1 & addr2 & addr3 & delimiter>
                        <cfset record = record & state & delimiter>
                        <cfset record = record & city & delimiter>
                        <cfset record = record & country_code & delimiter>
                        <cfset record = record & postal_code & delimiter>
                        <cfset record = record & contact_phone & delimiter>
                        <cfset record = record & tax_id_num & delimiter>
                        <cfset record = record & tax_code & delimiter>
                        <cfset record = record & exp_acct_code & delimiter> ----->
                        <cfset lven = cven>
                  </cfif>
            
      <cfif store_output eq "Yes">
            <CFFILE ACTION="APPEND" FILE="#file#" OUTPUT="#record#" ADDNEWLINE="Yes">
      </cfif>
      </cfloop>

</cfif>
</table>
</cfoutput>
0
DancingFighterG
Asked:
DancingFighterG
  • 3
  • 2
1 Solution
 
aseusaincCommented:
Change the way you build #record# and get rid of all the &'s.

<cfset record = "#record##addr1# #addr2# #addr3#,">
0
 
aseusaincCommented:
You can build it all on one line if you like as well...

<cfif store_output eq "Yes" and lven NEQ vendor_code >
<cfset record = "#vendor_code#,#address_name#,#addr1# #addr2# #addr3#,#state#,#city#,#country_code#,#postal_code#,#contact_phone#,#tax_id_num#,#tax_code#,#exp_acct_code#">
<cfset lven = cven>
</cfif>


0
 
DancingFighterGAuthor Commented:
Man, that makes me so angry that it was so much easier than what I was doing. thanks you. one more thing, is there anyway within this that I can format it where each value is in a seperate colum. I'm exporting the file in excel.
0
 
aseusaincCommented:
The above code is comma delimited.  Just save it as a .txt file and open it with Excel.  Excel will open up a wizard that will let you confirm the columning.
0
 
DancingFighterGAuthor Commented:
Cool, thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now