Re: FOR XML, TYPE seems broken with latest 1.0x

A tdsdump would be helpful. Probably they are using dblib

Frediano
On 7 Jul 2016 22:57, "Harris, Sean" <[email protected]> wrote:

> Sorry for the delay.
>
> It was working before. We are using PHP PDO to query the database.
> Interestingly an App we use from the MacApp store recently updated it’s
> internal build of FreeTDS and it stopped working for these queries too.
> That app is SQLPro for MSSQL.app
>
> We run the same PHP code on a windows box except we use Microsoft’s driver
> ‘SQLSRV’ and it works just fine.
>
> Sean Harris
> Studio N Tech Operations
>
> On Jul 5, 2016, at 1:08 PM, Frediano Ziglio <[email protected]<mailto:
> [email protected]>> wrote:
>
> On 5 Jul 2016 17:06, "Harris, Sean" <[email protected]<mailto:
> [email protected]>> 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
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds