Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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
>




Archive powered by MHonArc 2.6.24.

Top of Page