Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Neat Fox-to-Sql parm object works but has problem
Message
 
 
To
17/09/2003 10:27:31
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00829659
Message ID:
00829880
Views:
27
You can use < pre > and < /pre > tags (w/o spaces) to preserve formatting. Why didn't you try
SELECT *
        FROM    OPENXML ( @idoc , '/*/*' )
        WITH    ( pk INT '.')
?

>Here is some SQL test code that I am using along with the results that I get (at bottom). Actually, I had to remove the XML from this reply because of "style attributes not allowed inside a tag".
>
>declare @idoc int
>declare @doc varchar(8000)
>
>set @doc ='
>{XML Pasted in from fox's
> "CURSORTOXML([SqlParm],[lxData],1,2,0,[],[],[http://www.ourcompany.com])"
>'
>--Create an internal representation of the XML document.
>exec sp_xml_preparedocument @idoc OUTPUT, @doc
>
>SELECT *
> FROM OPENXML ( @idoc , '/*/*' )
> WITH ( pk INT )
>
>EXEC sp_xml_removedocument @idoc
>
>/*
>I get this:
>
>pk
>-----
>NULL
>NULL
>NULL
>
>*/
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform