Solved

outputing one file to a file at a time.

Posted on 2006-06-14
5
153 Views
Last Modified: 2013-12-24
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
Comment
Question by:DancingFighterG
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:aseusainc
ID: 16907473
Change the way you build #record# and get rid of all the &'s.

<cfset record = "#record##addr1# #addr2# #addr3#,">
0
 
LVL 7

Accepted Solution

by:
aseusainc earned 30 total points
ID: 16907515
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
 

Author Comment

by:DancingFighterG
ID: 16907836
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
 
LVL 7

Expert Comment

by:aseusainc
ID: 16907861
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
 

Author Comment

by:DancingFighterG
ID: 16907872
Cool, thank you!
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question