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 Microsoft has no desire to enhance or fix it. -- bob On Mon, 18 Aug 2003, Daniel Cher wrote: > 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> > <customer id="1" name="Alfred Futt"/> > <customer id="2" etc./> > </root> > > Any help appreciated. > > 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
