Download a Query

[RV Chris]

I manage a database on a website using Coldfusion. Several people use this and
I want to give them the ability to get whatever data they want and download it
to their own computers so they can work with it in Excel, for example.

It would be nice if I could give them the choice of what fields to download,
but just 'dumping' an entire table would be OK. I don't even know where to
start. Any guidance would be appreciated.

Thanx
Chris

[ranger]

simple... select 'field1, field2, field3' AS catz from that_table <cfoutput>
#catz# </cfoutput> to output specific fields, form page could select fields as
same input name which would post to query as comma deliminated list of form
fields <input type='checkbox' name='fields' value='field1'>field1 <input
type='checkbox' name='fields' value='field2'>field2 select #fields# from
that_table

[RV Chris]

When I try that I get an error about Complex object types cannot be converted
to simple values.
Also, I want the user to be able to download the data to a comma delimited
file on their own computers.
??

[philh]

Hi Chris, Look up CFCONTENT.

Using the CFEXAMPLES database:

<Cfquery name="getdata" datasource="sql">
select top 10 * from Customers</CFQUERY>
<cfset content="">
<cfloop index="thisfield" list="#getdata.columnlist#">
<cfset content=content&thisfield&chr(9)>
</cfloop>
<cfset content=mid(content,1,len(content)-1)&chr(13)>
<Cfoutput query="getdata">
<cfloop index="thisfield" list="#getdata.columnlist#">
<Cfset content=content&evaluate(thisfield)&chr(9)>
</cfloop>
<cfset content=mid(content,1,len(content)-1)&chr(13)>
</cfoutput>

<cfcontent type="application/vnd.ms-excel"><cfoutput>#content#</cfoutput>

[zoeski80]

RV Chris

Are any of your database columns variable scope names eg SERVER, URL, FORM
because that is usually what gives the error about complex data types you got
above. You might need to do a bit of a rename of columns before displaying them
*shrugs*

HTH