HOW TO EXPORT OUTPUT TO TEXT FILE?

[olchik]

Hello, I was trying to export output to TXT file, but I keep getting error.
My code:
<cffile action = "write" file = "file="#GetTempDirectory()#homepagerank.txt" output = "Rank: #get_admin_rank.admin_rank# Headline: #get_admin_rank.headline# URL: #get_admin_rank.headline# Image Path: #get_admin_rank.image_path# Description: #get_admin_rank.description# Related: #get_admin_rank.related_headline# Related URL: #get_admin_rank.related_url#">

Error:

Error Occurred While Processing Request
An error occurred when performing a file operation write on file h:\secure\homepage\homepagerank.txt.
The cause of this exception was: java.io.FileNotFoundException: h:\secure\homepage\homepagerank.txt (The system cannot find the path specified).

The error occurred in D:\Inetpub\

http://wwwroot\Secure\HomePage\admin\export_to_textfile.cfm:

line 16

14 : ORDER BY admin_rank DESC
15 : </cfquery>
16 : <cffile action = "write" file = "h:\secure\homepage\homepagerank.txt" output = "Rank: #get_admin_rank.admin_rank# Headline: #get_admin_rank.headline# URL: #get_admin_rank.headline# Image Path: #get_admin_rank.image_path# Description: #get_admin_rank.description# Related: #get_admin_rank.related_headline# Related URL: #get_admin_rank.related_url#">

WHat am I doing wrong?

Thank you
Olchik

 

[GUJUm0deL]

That error means that <cffile> does not have permission to create a file at h:\secure\homepage\homepagerank.txt

Check the server permissions.

Also make sure that in the H: there is a directory called \homepage\ so homepagerank.txt can be saved there.

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[olchik]

Hi GUJUm0deL, <cffile> permissions are there and homepage directory exists :-( Is there any other reasons for it not to work?

Thank you

 

[olchik]

Now I have another problem. When I click on a link to the file that has this <cffile> tag, I get empty page... Does anybody know what may be a problem? PLEASE HELP!

 

[DonHawaii]

Try this to see what your actual path is:
<cfoutput>GETDIRECTORYFROMPATH(#CGI.CF_TEMPLATE_PATH#)</cfoutput>

Just have it output so you can be sure of what the path is. Always good to verify the path.


DonOmite
<a href="

http://www.donomite.com">Destroying

Your Fear of The Web</a>