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.
> I'd like to use Microsoft SQL Server 2000 XML capabilities for
> query results in XML. It is very easy, just say "for xml auto" at the
> your query.
> The problem is that I cannot seem to retrieve the results back into
> Anyone ever accomplish this?
> 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