-
[SQLXML] - Results not in good XML wrapper???
Hi all,
I have a stored proc that is begin called, and it is returning data that is not properly formatted (no root tags)
my stored proc is a simple one...
================================================== =====================
CREATE PROCEDURE [SP_XML_Get_Active_Users_By_VenueID]
(@venueID int)
AS
SELECT *
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
================================================== =====================
I am trying to call it from a web browser via this line....
http://laptop/heh?sql=execute+sp_xml_get_active_users_by_venueid +657
When the results are passed back there is not root tags....
now when i call it with this URL...
http://laptop/heh?sql=execute+sp_xml_get_active_users_by_venueid +657&root=root
It returns a fully qualified XML doc... with the root tags....
Does anyone have an idea why the stored proc is not returnning a fully qualified XML document????
thanks
tony
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|