OK. this is what I sent Neil, that can be opened in excel... which is
similar!
<cfquery name="getcopy" datasource="datasource">
select * from table
</cfquery>
<table border="1" bordercolor="white" bordercolordark="gray"
bordercolorlight="gray" cellspacing="0">
<tr>
<cfloop list="#getcopy.columnlist#" index="ii">
<td><font size="-2"
face="Arial"><cfoutput><b>#lcase(ii)#</b></cfoutput></font></td>
</cfloop>
</tr>
<cfloop query="getcopy">
<tr valign="top" bgcolor="<cfoutput>#iif(getcopy.currentrow mod 2,
de("silver"), de("white"))#</cfoutput>">
<cfloop list="#getcopy.columnlist#" index="ii">
<td><font size="-2" face="Arial"><cfoutput>#iif(len(trim(evaluate(ii))),
'evaluate(ii)', de(" "))#</cfoutput></font></td>
</cfloop>
</tr>
</cfloop>
</table>
----- Original Message -----
From: "Paul Johnston" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 10:12 AM
Subject: RE: [ cf-dev ] Query to Text
> 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]
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
** 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]
