The win32 version of the mssql extension does not support the FOR
XML clause because it sends the results using ntext, which is the new
UNICODE text type introduced in SQL Server 7.0.
The mssql extension was built with DB-Library, which cannot read ntext
fields. DB-Library is obsolete, and
I've been trying for months to figure out how to get for xml auto queries
to work from PHP. I've got it working from ASP, which I strongly disprefer
(hate!).
I'd simply like to do:
$sql = select * from customers for xml auto;
$xml = $mssql-execute($sql);
echo $xml
This should return:
root
