Hi all,

I am getting some weird results from SQLXML under xppro
I have exposed s tored proc through the SQLXML setup, and can execute it via a URL in a browser....

here is the URL line....

http://laptop/heh?sql=execute+sp_xml...by_venueid+657

when it runs i get this error error...

Only one top level element is allowed in an XML document. Error processing resource 'http://laptop/heh?sql=execute+sp_xml_get_active_users_by_venueid +657'. Line 1, Position 292


but when i execute this URL....

http://laptop/heh?sql=execute+sp_xml...+657&root=root

(note the appeneded root=root)

i get a fully qualified xml document in the browser...

Here is the stored proc....

CREATE PROCEDURE [SP_XML_Get_Active_Users_By_VenueID]
(
@venueID int
)

AS

SELECT Users.*
FROM Users INNER JOIN
User_Venue_XRef ON Users.UserID = User_Venue_XRef.UserID INNER JOIN
Venues ON User_Venue_XRef.VenueID = Venues.VenueID
WHERE (User_Venue_XRef.VenueID = @venueID) AND (Users.Deleted = 0)
FOR XML AUTO
GO



Anyone know what is going on here????


thanks
tony