Re: Converting a recordset to XML

2003-02-26 Thread Taco Fleur
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

2003-02-26 Thread Andre Mohamed
: 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

2003-02-26 Thread Taco Fleur
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

RE: Converting a recordset to XML

2003-02-25 Thread Collin Tobin
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

RE: Converting a recordset to XML

2003-02-25 Thread Andre Mohamed
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