[freetds] FOR XML, TYPE seems broken with latest 1.0x

Frediano Ziglio freddy77 at gmail.com
Tue Jul 5 16:08:53 EDT 2016


On 5 Jul 2016 17:06, "Harris, Sean" <Sean.Harris at nordstrom.com> wrote:
>
> Hey guys,
>
> So I updated a mac dev machine to the latest release available via home
brew (1.00.9).
>
> After this any queries using the TYPE directive for XML return an unknown
type error.
>
> example query: SELECT * FROM users WHERE id = 123 FOR XML PATH('users'),
ROOT('xmlObject'), TYPE
>
> About the TYPE directive:
https://msdn.microsoft.com/en-us/library/ms190025.aspx
>

Which tool are you using for doing the query?

Frediano


More information about the FreeTDS mailing list