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=subscribeforumid=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
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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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=subscribeforumid=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
RE: Converting a recordset to XML
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 first#Strfname#/first last#Strlname#/last /name /cfoutput /employee /cfxml cfdump var=#EmployeeDoc# Collin Tobin CFMX QA Engineer Macromedia® What the web can be.(tm) Announcing Macromedia DevNet Subscriptions Maximize your power with our new premium software subscription for Macromedia developers Find out more: http://www.macromedia.com/go/devnetsubs/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 9:41 AM 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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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=subscribeforumid=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