I've been trying to export my database to an xml file. While largely successful, I'm still having troubles. With the code below, everything works fine except that it doesn't put the </channel></rss> at the bottom of the page, but instead ends with </item>. I need those tags for proper rss validation.
The file: http://hhp.umd.edu/rss/whats_new.xml The failed validation: http://feedvalidator.org/check.cgi?url=http%3A%2F%2Fhhp.umd.edu%2Frss% 2Fwhats_new.xml A here's the code: <cfquery name="retrieve_xml" datasource="dpch"> SELECT header,description,id FROM whats_new ORDER BY id DESC </cfquery> <cfsavecontent variable="xml"><?xml version="1.0" ?> <rss version="2.0"> <channel> <title>Health and Human Performance - What's New</title> <description>This is the University of Maryland's College of Health and Human Performance list of What's new items.</description> <link>http://hhp.umd.edu</link> <cfoutput query="retrieve_xml"> <cfset desc_length = 400> <CFIF LEN(description) gt desc_length> <CFSET desc = LEFT(description,desc_length)> <cfset desc = ListDeleteAt(desc, ListLen(desc, " "), " ")> <!--- deletes to the last full word ---> <cfset desc = desc & "..."> <cfelse> <CFSET desc = description> </CFIF> <CF_RENoTags input="#desc#" variable="desc" > <cfset the_header = header> <CF_RENoTags input="#header#" variable="the_header" > <item> <title>#the_header#</title> <description>#desc#</description> <link>http://hhp.umd.edu/whats_new.cfm?id=#id#</link> </item> </cfoutput> </channel> </rss> </cfsavecontent> <cffile action="write" file="#CurrentDir#rss/whats_new.xml" output="#xml#" addnewline="no"> thanks for any help, or just for listening. _____________________________ Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226809 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
