Alternative to CFFILE to write a text file?

[jmk6281]

My hosting company has CFFILE disabled (for security). I'm trying to test a program where I do a query of an Access database. I know CFFILE would then allow me to popular the data of this query into a .txt or .xls file where I could eventually have my client download it.

However, I'm stuck without CFFILE ability. Is there any other suggested way to populate a text fil(or excel) after a do a CFQUERY? I was looking at CFHTTP, but I'm not sure that would work.

Thanks!

 

[pcorreia]

Well, you could write a text file dynamically in ColdFusion every time the client downloaded it:

<cfquery name=&quot;myQuery&quot;>
   SELECT ID,Name,Code
   FROM myTable
</cfquery>

<cfcontent type=&quot;text/plain&quot; reset=&quot;Yes&quot;>
<cfheader name=&quot;Content-Disposition&quot; value=&quot;attachment;filename=myfile.txt&quot;>
ID,Name,Code
<cfoutput query=&quot;myQuery&quot;>#ID#,#Name#,#Code#
</cfoutput>

When the browser requests this .cfm page, the response from the server will be a text file called myfile.txt.

 

[jmk6281]

Unfortunately, they also have CFCONTENT (and CFDIRECTORY, CFOBJECT, CFREGISTRY, CFFILE) disabled. Yes, I should probably find a hosting company that allows full access, but I picked them just as I was getting started in Cold Fusion, and I did not realize that this would be an issue.

Any other ideas??? Or good CF Hosting companies?

 

[pcorreia]

You could do this without <CFCONTENT>, as long as you can use <CFHEADER>. Replace this code:

<cfcontent type=&quot;text/plain&quot; reset=&quot;Yes&quot;>

With this code:

<cfheader name=&quot;Content-Type&quot; value=&quot;text/plain&quot;>

In this case, though, any whitespace that has accumulated before you start the output will be included in the text file, so you'll want to minimize the extra white space as much as possible.

 

[SidianConsulting]

If you need a new web hosting company, check out CF HOSTING:

http://www.cfhosting.com/shared_server.cfm

I've heard good things about them, but I haven't used them and am not in league with them by any means.

-Tek