creating rtf files

[Dave199]

Hi

I'm following an example in a Macromedia textbook; it's designed to return obe
row whereas I want to return several rows. I can't get it to this even though
I've tried several variations of cfloop - I'd appreciate any advice!

Here's my code:

<cfquery name="q1" datasource="mysource">
select * from resources, month_lookup where
resources.month=month_lookup.month_num order by keyword1, keyword2, keyword3
</cfquery>

<cfset thisFolder = getDirectoryFromPath(getCurrentTemplatePath())>
<cfset templatePath = thisFolder & "resource.rtf">
<cffile action="read" file="#templatePath#" variable="rtf">

<cfset rtf= replace(rtf, "%keyword1%", q1.keyword1, "ALL")>
<cfset rtf= replace(rtf, "%keyword2%", q1.keyword2, "ALL")>
<cfset rtf= replace(rtf, "%keyword3%", q1.keyword3, "ALL")>
<cfset rtf= replace(rtf, "%contributor%", q1.contributor, "ALL")>
<cfset rtf= replace(rtf, "%month_name%", q1.month_name, "ALL")>
<cfset rtf= replace(rtf, "%year%", q1.year, "ALL")>
<cfset rtf= replace(rtf, "%information%", q1.information, "ALL")>

<cfheader name="Content-Disposition" value="filename=uklast92.doc">
<cfcontent type="application/msword"> <cfoutput>#rtf#</cfoutput>


Many thanks

Dave S

[mxstu]

If your query returns more than one row, you could use <cfloop query="q1"

>...</cfloop> to loop through each row of the query. However, if you enclosed

your current code in a cfloop, I think the first loop would replace all of the
"%keyword1%, etc..." strings and subsequent loops would probably do nothing,
because all of the replacements were already done. What are you trying to do?

[Dave199]

Thanks for thr answer - I'm trying to return all the rows of the query, of
which there are several, into one rtf file. And my various cfloop efforts were
around the "%..%" lines. But I can't work out what else to do on this one.

Regards

Dave S

[BKBK]

Does this do you?

<cfset original_rtf = rtf>
<cfset final_rtf = "">

<cfloop query="q1">
<cfset rtf= replace(rtf, "%keyword1%", q1.keyword1, "ALL")>
<cfset rtf= replace(rtf, "%keyword2%", q1.keyword2, "ALL")>
<cfset rtf= replace(rtf, "%keyword3%", q1.keyword3, "ALL")>
<cfset rtf= replace(rtf, "%contributor%", q1.contributor, "ALL")>
<cfset rtf= replace(rtf, "%month_name%", q1.month_name, "ALL")>
<cfset rtf= replace(rtf, "%year%", q1.year, "ALL")>
<cfset rtf= replace(rtf, "%information%", q1.information, "ALL")>

<!--- final modified rtf for the respective query row--->
<cfset final_rtf = final_rtf & rtf>

<!--- reset to oginal rtf before you begin replacements for new query row--->
<cfset rtf = original_rtf>

</cfloop>

<cfheader name="Content-Disposition" value="filename=uklast92.doc">
<cfcontent type="application/msword"> <cfoutput>#final_rtf#</cfoutput>

[Dave199]

Yes thank you BKBK, that's spot on! Such a neat and simple solution, I must try to think more laterally and stopped getting bogged down.

Best wishes

[mxstu]

Dave199,

Maybe it's just late, but as I said before, I don't see the purpose of the
loop. You are reading the entire contents of the file into the "rtf" variable.
In the first iteration of the query loop, your CFSET statements will replace
ALL of the words enclosed in percent signs.

<cfset rtf= replace(rtf, "%keyword1%", q1.keyword1, "ALL")>
... etc...

Since you are replacing ALL of the occurrences, there will be nothing to
replace after the first loop. Therefore subsequent iterations of the loop will
probably do nothing. So, am I missing something here?