Ajas, that's a really neat function. Looks like it is indeed undocumented.
It's a method of the cfquery resultset object (it works in CFMX 6.1 as well
as 7). I modified the line setting mycollist in my code to use that, and the
line following it, to be:
#listchangedelims(mycollist,sep,",")##ne
Hi Charlie, Thanks for the input again. I was thinking of doing it manually
and I guess thats what you are saying also and it involves typing the 84
column names in a variable. Correct me if I am wrong in my assumption here.
I found a solution to this problem and to be honest I am quite surprised
Thanks, Ajas. As for your challenge, here's a simple solution (sorry I
didn't think to mention it yesterday).
Put the list of columns you want to select in a variable, and use that
variable in your SELECT (as in SELECT #mycollist# from ...) and then remove
the line where I created it as a result
Charlie, All I can say is wow... Its a very neat & clean code... Thank you
so much. I am bit sad myself as I didnt come up with a solution. Still
learning I guess :-(
answer to some of your questions --> Yes file has to be tab delimited. We
send export file to client which should be a tab del
Thanks. After reading through this, since it does a UNION ALL and that
can result in duplicates, could a DISTINCT help this or just annoy it?
mcg
"Fennell, Mark P." <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/13/2007 04:35 PM
Please respond to
discussion@acfug.org
To
discussion@acfu