RE: SQLXML

2003-06-09 Thread Cantrell, Adam 
John, cool stuff indeed. Do you have the SOAP toolkit 2.0 or 3.0 installed
on the server? Does it matter?

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]
 
 
~|
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

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQLXML

2003-06-09 Thread jon hall 
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=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SQLXML

2003-06-09 Thread Shawn Regan 
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=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQLXML

2003-06-09 Thread CF Dude 
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=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: SQLXML

2003-06-09 Thread Cantrell, Adam 
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-84E4FF655A3Bdisplaylang=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=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

SQLXML

2003-06-08 Thread jonhall 
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]

~|
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