CFILE and APPEND

2 Message(s) by 2 Author(s) originally posted in cold fusion

From: Chris

Date: Friday, May 11, 2007

Hi everyone, I need your help with the following issue:

I am using Cold Fusion MX7:
Version 7,0,2,142559 on Windows

<operating system> See {Microsoft Windows}, {Windows NT}.

	(1997-11-23)

2000 Server
--------------------------------------------

I am getting duplicate line

1. <hardware> An electrical conductor.  For distances larger
	than a breadbox, a single line may consist of two electrical
	conductors in twisted, parallel, or concentric arrangement
	used to transport one logical signal.

	By extension, a (usually physical) medium such as an {optical
	fibre} which carries a signal.

	(1995-09-29)

s written out to my Report.CSV file

<file system> An element of data storage in a {file system}.

	The history of computing is rich in varied kinds of files and
	{file systems}, whether ornate (e.g., {Macintosh file system}
	for a well-known case) or deficient (e.g., many simple
	pre-1980s file systems don't allow {directories}).

	However, the prototypical file has these characteristics:

	* It is a single sequence of bytes (but consider {Macintosh}
	{resource forks}).

	* It has a finite length, unlike, e.g. a {Unix} {device}.

	* It is stored in a {non-volatile storage} medium (but see
	{ramdrive}).

	* It exists (nominally) in a {directory}.

	* It has a name that it can be referred to by in file
	operations, possibly in combination with its {path}.

	Additionally, a file system may associate other information
	with a file, such as {permission} bits or other {file
	attributes}; timestamps for file creation, last revision, and
	last access; revision numbers (a` la VMS), and other kinds of
	{magic}.

	Compare: {document}.

	(1997-04-08)

.

...and here is an example of the code

<software> Instructions for a computer in some programming
	language, often {machine language}.  The word "code" is often
	used to distinguish instructions from {data} (e.g. "The code
	is marked 'read-only'") whereas "{software}" is used in
	contrast with "{hardware}" and may consist of more than just
	code.

	(2000-04-08)

in use:
<CFFILE action="write

1. <chat> {Unix}'s simple {talk} command and {protocol}.
	write has been largely superseded by {talk} and then {irc}.

	An enhancement, {RWP}, has been proposed.

	2. <tool> A simple {text editor} for {Windows}.

	(1998-04-28)

" file="D:\Foo\Bar\#OutFile#" output="ColA, ColB, ColC, ColD, ColE">

<!--- Then I loop

<programming> A sequence of {instructions} that the
	{processor} repeats, either until some condition is met, or
	indefinitely.

	In an {structured language} (e.g. {C}, {Pascal}, {BASIC}, or
	{Fortran}), a loop is usually achieved with {for loop}, {while
	loop} or {repeat loop} constructs.

	In other languages these constructs may be synthesised with a
	{jump} ({assembly language}) or a {GOTO} (early Fortran or
	BASIC).

	(1999-05-06)

through the query

1. <database, information science> A user's (or {agent}'s)
	request for information, generally as a formal request to a
	{database} or {search engine}.

	{SQL} is the most common {database query language}.

	2. <character> {question mark}.

	(1997-04-09)

and write out the corrosponding records: --->
<CFLOOP query="ResultsSet">
<CFSET TextLine = trim(numberformat(x.ColA,-99.999999)) & "," &
trim(numberformat(x.ColB,999.999999)) & "," &
#ColC# & "," & #ColD#&","&#ColE#>

<CFFILE action="append" file="D:\Foo\Bar\#OutFile#" output="#TextLine#"
addnewline="yes">
</CFLOOP>NOTE: The above query has been checked during its execution, in that
only a certain number of iterations are performed by the loop.

For example, if I print a line of text

1. Executable code, especially a "pure code" portion shared
	between multiple instances of a program running in a
	{multitasking} {operating system}.

	Compare {English}.

	2. Textual material in the mainstream sense; data in ordinary
	{ASCII} or {EBCDIC} representation (see {flat ASCII}).  "Those
	are text files; you can review them using the editor."

	These two contradictory senses confuse hackers too.

	[{Jargon File}]

	(1995-03-16)

from within the loop to the page,
i.e: Am here </BR>, I get the correct number of lines printed out as HTML,
which corrosponds to the correct number of records retrieved by the query.

However, the resulting OutFile (report.CSV) file produced is twice the size
with duplicate records in it!

Is this a known bug, and if so, is there a fix for it?

Thanks in advance,
Chris

From: Denard Springle

Date: Monday, June 25, 2007

<CFLOOP query="ResultsSet">
<CFSET TextLine = trim(numberformat(x.ColA,-99.999999)) & "," &
trim(numberformat(x.ColB,999.999999)) & "," &
#ColC# & "," & #ColD#&","&#ColE#>
<CFFILE action="append" file="D:\Foo\Bar\#OutFile#" output="#TextLine#"
addnewline="yes">
</CFLOOP>Not sure why it's giving you double records without seeing all the

code, however, two things you can do:

1. Insert: <CFOUTPUT>#TextLine#</CFOUTPUT><br /> before CFFILE append
2. Comment out the CFFILE append (temporarily)
3. Run the script and see if you're getting duplicate results on
screen.

If yes, then there's something wrong with the way you're producing
TextLine.

If no, try creating a single variable

<programming> (Sometimes "var" /veir/ or /var/) A named memory
	location in which a program can store intermediate results and
	from which it can read it them.  Each {programming language}
	has different rules about how variables can be named, typed,
	and used.  Typically, a value is "assigned" to a variable in
	an {assignment} statement.  The value is obtained by
	evaluating an expression and then stored in the variable.  For
	example, the assignment

		x = y + 1

	means "add one to y and store the result in x".  This may look
	like a mathematical equation but the mathematical equality is
	only true in the program until the value of x or y changes.
	Furthermore, statements like

		x = x + 1

	are common.  This means "add one to x", which only makes sense
	as a state changing operation, not as a mathematical equality.

	The simplest form of variable corresponds to a single-{word}
	of {memory} or a {CPU} {register} and an assignment to a
	{load} or {store} {machine code} operation.

	A variable is usually defined to have a {type}, which never
	changes, and which defines the set of values the variable can
	hold.  A type may specify a single ("atomic") value or a
	collection ("aggregate") of values of the same or different
	types.  A common aggregate type is the {array} - a set of
	values, one of which can be selected by supplying a numerical
	{index}.

	Languages may be {untyped}, {weakly typed}, {strongly typed},
	or some combination.  {Object-oriented programming} languages
	extend this to {object} types or {classes}.

	A variable's {scope} is the region of the program source
	within which it represents a certain thing.  Scoping rules are
	also highly language dependent but most serious languages
	support both {local variables} and {global variables}.
	{Subroutine} and {function} {formal arguments} are special
	variables which are set automatically by the language runtime
	on entry to the subroutine.

	In a {functional programming} language, a variable's value
	never changes and change of state is handled as recursion over
	lists of values.

	(2004-11-16)

and writing the whole thing at
once, i.e.:

<CFSET textLine = "ColA,ColB,ColC,ColD,ColE" & chr(10)>
<CFLOOP query="ResultsSet">
<CFSET textLine = textLine & trim(numberformat(x.ColA,-99.999999)) &
"," &
trim(numberformat(x.ColB,999.999999)) & "," &
ColC & "," & ColD & "," & ColE & chr(10)>
</CFLOOP>
<CFFILE action="write" file="D:\Foo\Bar\#OutFile#"
output="#textLine#">

The chr(10) is the linefeed character

<character> An {atom} in a {character repertoire}.

	Compare with {glyph}.

	(1998-10-18)

which should be suitable
for .csv creation, however you can also use chr(13) which is the
carriage return, which should also work for .csv creation (and may
make it easier to read on Windoze).

In short, I have never heard of ColdFusion

<World-Wide Web, database, tool> {Allaire Corporation}'s
	commercial {database} application development tool that allows
	{databases} to have a {World-Wide Web} {interface}, so a
	database can be queried and updated using a {web browser}.

	The ColdFusion Server application runs on the {web server} and
	has access to a {database}.  ColdFusion files on the web
	server are {HTML} pages with additional ColdFusion commands to
	{query} or {update} the database, written in {CFML}.  When the
	page is requested by the user, the {web server} passes the
	page to the Cold Fusion application, which executes the {CFML}
	commands, places the results of the {CFML} commands in the
	{HTML} file, and returns the page to the {web server}.  The
	page returned to the {web server} is now an ordinary {HTML}
	file, and it is sent to the user.

	Examples of ColdFusion applications include order entry, event
	registration, catalogue search, directories, calendars, and
	interactive training.  ColdFusion applications are robust
	because all database interactions are encapsulated in a single
	industrial-strength {CGI} script.  The formatting and
	presentation can be modified and revised at any time (as
	opposed to having to edit and recompile {source code}).

	ColdFusion Server can connect with any database that supports
	{ODBC} or {OLE DB} or one that has a native database driver.
	Native database drivers are available for {Oracle} and
	{Sybase} databases.

	ColdFusion is available for {Windows}, {Solaris}, and {HP-UX}.
	A {development environment} for creating ColdFusion files,
	called ColdFusion Studio, is also available for {Windows}.

	Current version: MX(6), as of 2003-07-11.

	The {filename extension} for ColdFusion files is .cfm

	{Home (http://www.coldfusion.com/)}.

	(2003-07-27)

having any known issues that'd
cause this behavior (not that I'm the authority or anything <g>) and
would lean more towards something awry in either the dataset, query or
the way you're constructing the .csv.
Hope this helps!

-- Denny

Next Message: On line vorting