Try this:
<cfquery name="myQuery" datasource="#dsn#">
SELECT *
FROM myTable
</cfquery>
<!--- create the dumpvar --->
<cfset dumpvar = "">
<!--- output the column list as the first line --->
<cfset counter = 1>
<cfloop list="#myQuery.columnlist#" index="col">
<cfset dumpvar = dumpvar & """" & col & """">
<cfif counter neq ListLen(myquery.columnlist)>
<cfset dumpvar = dumpvar & ",">
</cfif>
<cfset counter = counter + 1>
</cfloop>
<!--- loop over the query and output the data (in double quotes, although
double quotes are not escaped in the code) --->
<cfloop query="myQuery">
<cfset counter = 1>
<cfloop list="#myQuery.columnlist#" index="col">
<cfset dumpvar = dumpvar & """" & evaluate(col) & """" >
<cfif counter neq ListLen(myquery.columnlist)>
<cfset dumpvar = dumpvar & ",">
</cfif>
<cfset counter = counter + 1>
</cfloop>
<cfset dumpvar = dumpvar & "#chr(13)#">
</cfloop>
<!--- output dumpvar to file --->
<cfoutput><pre>#dumpvar#</pre></cfoutput>
>
> On a deadline : anyone got a CT which can take a query and
> dump it to a delimited text file (ideally user declared) with
> little or no hassle?
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED] For human help, e-mail:
> [EMAIL PROTECTED]
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
