freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x
- From: Frediano Ziglio <freddy77 AT gmail.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x
- Date: Thu, 7 Jul 2016 22:37:20 +0100
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
>
-
[freetds] FOR XML, TYPE seems broken with latest 1.0x,
Harris, Sean, 07/04/2016
- Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x, Igor Korot, 07/05/2016
-
Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x,
Frediano Ziglio, 07/05/2016
-
Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x,
Harris, Sean, 07/06/2016
- Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x, Frediano Ziglio, 07/07/2016
-
Re: [freetds] FOR XML, TYPE seems broken with latest 1.0x,
Harris, Sean, 07/06/2016
Archive powered by MHonArc 2.6.24.