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

Frediano Ziglio freddy77 at gmail.com
Thu Jul 7 17:37:20 EDT 2016


A tdsdump would be helpful. Probably they are using dblib

Frediano
On 7 Jul 2016 22:57, "Harris, Sean" <Sean.Harris at nordstrom.com> 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 <freddy77 at gmail.com<mailto:
> freddy77 at gmail.com>> wrote:
>
> On 5 Jul 2016 17:06, "Harris, Sean" <Sean.Harris at nordstrom.com<mailto:
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>


More information about the FreeTDS mailing list