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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
