If you only need to make a list out of a single column try using
VALUELIST(query.column) function to convert the query result to a csv list.
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 10:13 AM
To: CF-Talk
Subject: CSV file;CFFILE;Sybase IQ12
Hi all. Hoping someone who has "BEEN THERE, DONE THAT" can help.
Have to create a csv file from a cfquery resultset which can then be
imported
into a number
of programs that do statistical analysis.
Approximately 5000 rows/records with a final size of 1730 kb.
A sql count and the display of the first 10 rows to screen is only a matter
of
seconds.
Using CFFILE to covert query to CSV was VERY SLOW (intranet: approx. 1
min/1000
rows).
NOT ACCEPTIBLE.
Downloading the file to the client machine is a matter of seconds (approx 1
sec/1000 rows).
Using SQL and concatenating the fields per record, much, much faster.
Easier, in SQL SYBASE IQ12 is to add the following after the last clause in
the
WHERE
statement: '> & newfile.txt'. The query WORKS in Interactive SQL, but when
the
SQL statement
is wrapped in the <CFQUERY>, it BOMBS out. Can't read the > as a piping
command.
So....The question: what is the OPTIMAL process for generating the CSV file.
Any and all help would be appreciated.
Thanks, in advance,
Carol
Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
