Re: Converting a recordset to XML

If you are using MS SQL you can convert the record set to XML with its XML publishing tools.. - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 12:50 AM Subject: RE: Converting a recordset to XML Brook

RE: Converting a recordset to XML

: Converting a recordset to XML If you are using MS SQL you can convert the record set to XML with its XML publishing tools.. - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 12:50 AM Subject: RE: Converting a recordset

Re: Converting a recordset to XML

oops... - Original Message - From: Andre Mohamed [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 7:33 PM Subject: RE: Converting a recordset to XML Taco, The original post pointed out that they were still using SQL Server 7.0 which I don't believe

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

RE: Converting a recordset to XML

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

RE: Converting a recordset to XML

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