Ahhh, I was going off of this page, which lists the SOAP toolkit as a requirement.: http://www.microsoft.com/downloads/details.aspx?FamilyId=4023DEEA-F179-45DE- B41D-84E4FF655A3B&displaylang=en
I knew SQL2K came with some XML capabilities, but didn't know it was as extensive as this page makes it out to be: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn ol/sql/evaluate/featfunc/xmlsql.asp The comparison table to Oracle is interesting as well. Adam. > -----Original Message----- > From: CF Dude [mailto:[EMAIL PROTECTED] > Sent: Monday, June 09, 2003 3:19 PM > To: CF-Talk > Subject: Re: SQLXML > > > msSql2k does have built in XML capabilities. Just search > from XML in the BOL. > > Eric > > ----- Original Message ----- > From: "Shawn Regan" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, June 09, 2003 3:59 PM > Subject: RE: SQLXML > > > As far as I know you don't even need Soap, At least with MS SQL2000. I > believe it has a built in function that returns XML > > Shawn Regan > > -----Original Message----- > From: jon hall [mailto:[EMAIL PROTECTED] > Sent: Monday, June 09, 2003 11:35 AM > To: CF-Talk > Subject: Re: SQLXML > > > Shouldn't matter, the stuff I was reading was based off 2.0, but I > installed 3.0 and it worked fine. > > -- > jon > mailto:[EMAIL PROTECTED] > > Monday, June 9, 2003, 2:06:27 PM, you wrote: > CA> John, cool stuff indeed. Do you have the SOAP toolkit 2.0 or 3.0 > installed > CA> on the server? Does it matter? > > CA> Adam. > > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >> Sent: Sunday, June 08, 2003 7:38 PM > >> To: CF-Talk > >> Subject: SQLXML > >> > >> > >> Just a quick note for anyone who hasn't gotten a chance to > play with > >> MSSQL SQLXML yet, here is snippet showing how to get SQL Server to > >> return XML to CF. > >> > >> The MS SOAP Toolkit and SQLXML both need to be installed > on the server > >> before this will work. > >> > >> > >> <cfquery datasource="northwind" name="xml"> > >> SELECT Customers.CustomerID, Orders.OrderID, Customers.ContactName > >> FROM Customers, Orders > >> WHERE Customers.CustomerID = Orders.CustomerID > >> FOR XML AUTO > >> </cfquery> > >> > >> <cfset column = xml.columnList> > >> > >> <cfset xmlStr = ''> > >> <cfloop from="1" to="#xml.recordCount#" index="i"> > >> <cfset xmlStr = xmlStr & xml[column][i]> > >> </cfloop> > >> > >> <root> > >> <cfoutput>#xmlStr#</cfoutput> > >> </root> > >> > >> > >> That's it...piece of cake. The only weird things are the > name of the > >> column that is returned by default is a bit odd, so I had to work > >> around that, and multiple records are returned representing one xml > >> document so they need to be concatenated. > >> If anyone has any info on how to change that or why that > is, I'm all > >> ears. > >> > >> -- > >> mailto:[EMAIL PROTECTED] > >> > >> > CA> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 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
