Re: FOR XML, TYPE seems broken with latest 1.0x
"Harris, Sean" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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