Hi, selectting XML data forces the result to be returned a a unicode text field. That is not suported by the DBLIB library (From Microsoft) used to build the mssql extension does not support that.
You can use ODBC or you can wait untill I have a working compy of FreeTDS on Win32. FreeTDS is developed to access MS SQL and Sybase servers from (nix, and I have just tested 'for xml auto' from my Mandrake 9.0 box to a SQL Server 2000, and it seams to be working. - Frank > Folks, > > I'd like to use Microsoft SQL Server 2000 XML capabilities for generating > query results in XML. It is very easy, just say "for xml auto" at the end of > your query. > > The problem is that I cannot seem to retrieve the results back into PHP. > Anyone ever accomplish this? > > Daniel > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php