Brook, If you're going via CF, you could try using WDDX as long as wherever you are sending it to can understand it. You'd this via the <cfwddx> tags passing in a CF variable e.g. a recordset. If converting a recordset into XML the quickest and EASIEST way is your MAIN criteria then this is probably the way to go.
If WDDX isn't what you want then there are a bunch of options, including using a Servlet filters to transform the WDDX XML into another XML format if need be but that requires some knowledge of XSLT etc. You could also just loop through the recordset and manually create the XML document in CF but this probably isn't recommended if the number of rows is large. Naturally, you could also do this inside of a stored procedure. Thanks, André -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 14:41 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
