How to <Cfoutput query=""> around <cffile>

[olchik]

I am trying to put query results in txt file. I know it will overwrite this txt file if I put <cfoutput query="queryname"> around <cffile>. Does anybody know how can I go around it? My query results in more than one record, but so far I get only one record in my TXT file.

 

[DonHawaii]

Use cffile action = append

This will put the new data onto the end of the file.

So first make sure the file exists, if not, create it. Then append to it.

DonOmite

http://www.donomite.com

 

[GUJUm0deL]

olchik, you seem to be posting a lot of threads relating to saving queryset results to a .TXT file, so I thought maybe an example might help:

<!--- GET RESULTSET --->
<cfquery name="getUser" datasource="#ds#">
	SELECT   User_ID, FirstName, LastName, City, State, Zip, Email
	FROM     myTable mT INNER JOIN Users U ON mT.User_ID = U.User_ID
</cfquery>	
  
<!--- sets the delimeter to doublequotes ["] --->
<cfset delimiter = chr(34)>
<!--- sets the text delimqual to: doublequotes comma doublequote [ "," ].  This is the closing quote, comma, opening quote.--->
<cfset delimqual = chr(34)&chr(44)&chr(34)>

<!--- sets the FileName var to a specific file name.  This is the file that gets emailed to the client, or FTP'd --->
<cfset FileName="GUJUm0deLExample_#DateFormat(now(),'mmddyyyy')#.txt">

<!--- sets the FullPathName to retrieve the file from the server from our side --->
<cfset FullPathName = "#getdirectoryfrompath(gettemplatepath())#files\#FileName#">

<!--- write to the file with certian outputs.  Since this resides before the loop, this will be the 'header' of the file --->
<cffile action="write" file="#FullPathName#" output="#delimiter#First Name#delimqual#Last Name#delimqual#City#delimqual#State#delimqual#Zip#delimqual#Email#delimiter#" addnewline="Yes">

<!--- outputs the query from above and groups it by the user id --->  
<cfoutput query="getUser" group="User_ID">
	<cffile action="append" file="#FullPathName#" output="#delimiter##FirstName##delimqual##LastName##delimqual##City##delimqual##State##delimqual##Zip##delimqual##Email##delimiter#" addnewline="Yes">
</cfoutput>

Hope this helps.

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[olchik]

Thank you DonHavaii, but "append" is not good in my case. I need this file be overwritten each time user searches. What I put in this txt file are search results. Each time user searches, the results are different and I need to overwrite old results with new.

Thank you again
Olchik

 

[olchik]

Hi GUJUm0deL, thank you for your example, but again..."append" is not good. I need ths file be overwritten each time <cffile> is called. Is there anyway to output(loop) inside cffile?

 

[olchik]

GUJUm0deL, stupid me...I cannot even use an example in a right way. Thank you very much! It worked...perfectly.

Thank you again
Olchik

 

[GUJUm0deL]

olchik, I'm glad the example helped.

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[DonHawaii]

I was going to say, then just recreate the file to start out with.

DonOmite

http://www.donomite.com