SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
Home Articles Editorials Forums Scripts Blogs QotD Books SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » convert SQL query to xml for use in creating...

convert SQL query to xml for use in creating spry dataset Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
pnealis
Posted Thursday, November 27, 2008 9:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 28, 2008 8:24 AM
Points: 1, Visits: 2
Hi, 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, type
FROM studentrentals
FOR XML auto

but when I use the resultant file the spry dataset cannot use it.

Can anyone shed light on me dilemma?

Thanks.
Post #610050
RBarryYoung
Posted Thursday, November 27, 2008 10:17 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 7,708, Visits: 6,917
You would probably have to start by telling us what a Spry database is and what it's requirements are.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
Post #610072
Jack Corbett
Posted Thursday, November 27, 2008 10:59 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:24 AM
Points: 6,301, Visits: 5,577
Can you provide the code you are using to create the Spry Dataset from the XML file?

Barry, here's a link to Spry http://livedocs.adobe.com/en_US/Spry/1.4/help.html?content=WSAD0FE19A-16F7-4479-9733-EA693A2B41CF.html. Apparently it's an Adobe technology.


Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Post #610092
RBarryYoung
Posted Friday, November 28, 2008 1:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 7,708, Visits: 6,917
Thanks Jack.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."
Post #610135
Jack Corbett
Posted Friday, November 28, 2008 7:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:24 AM
Points: 6,301, Visits: 5,577
No problem, Barry, I was interested in it, too. Kind of an interesting concept.


Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Post #610323
« Prev Topic | Next Topic »


Permissions Expand / Collapse

 
 
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use