Something like this will work: <cfquery name="getEmployees" datasource="SampleApps"> select * from tblEmp </cfquery>
<cfxml variable="EmployeeDoc"> <employee> <cfoutput query="getEmployees"> <name id="#strEmpID#"> <title>#strTitle#</title> <first>#Strfname#</first> <last>#Strlname#</last> </name> </cfoutput> </employee> </cfxml> <cfdump var="#EmployeeDoc#"> Collin Tobin CFMX QA Engineer MacromediaŽ What the web can be.(tm) Announcing Macromedia DevNet Subscriptions Maximize your power with our new premium software subscription for Macromedia developers Find out more: <http://www.macromedia.com/go/devnetsubs/> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 9:41 AM To: CF-Talk Subject: Converting a recordset to XML Hello, I'm trying to figure out what is the best way to convert a recordset in CFMX to XML. We're still using SQL 7.0, so we can not use the native XML features of SQL Server 2000. Would it make sense to select the data like this: Select '<title>' + title + ',</title> as title from movies Or is there a better way convert a record set to XML quickly? Are there any plugins for SQL Server. Brook Davies logiforms.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4