InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 08 Nov 2009 09:05:40 GMT20http://www.sqlservercentral.com/Forums/Topic610050-338-1.aspxNo problem, Barry, I was interested in it, too. Kind of an interesting concept.Fri, 28 Nov 2008 07:03:25 GMTJack Corbetthttp://www.sqlservercentral.com/Forums/Topic610050-338-1.aspxThanks Jack.Fri, 28 Nov 2008 01:11:23 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic610050-338-1.aspxCan you provide the code you are using to create the Spry Dataset from the XML file?Barry, here's a link to Spry [url]http://livedocs.adobe.com/en_US/Spry/1.4/help.html?content=WSAD0FE19A-16F7-4479-9733-EA693A2B41CF.html[/url]. Apparently it's an Adobe technology.Thu, 27 Nov 2008 22:59:00 GMTJack Corbetthttp://www.sqlservercentral.com/Forums/Topic610050-338-1.aspxYou would probably have to start by telling us what a Spry database is and what it's requirements are.Thu, 27 Nov 2008 22:17:38 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic610050-338-1.aspxHi, I am trying to create a xml dcocument from a query using SQL 2005 that I can use to create a spry dataset.I can create and xml document with this:SELECT Propno, address1, city, state, zip, typeFROM studentrentals FOR XML autobut when I use the resultant file the spry dataset cannot use it.Can anyone shed light on me dilemma?Thanks.Thu, 27 Nov 2008 21:19:19 GMTpnealis