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 has the XML publishing features of SQL Server 2000 > > Thanks, > > André > > -----Original Message----- > From: Taco Fleur [mailto:[EMAIL PROTECTED] > Sent: 26 February 2003 08:56 > To: CF-Talk > Subject: 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, > > > > 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