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
: 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
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
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
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
5 matches
Mail list logo