Re: [PHP-DB] for xml auto from MS Sql Server

2003-02-11 Thread Frank M. Kromann
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




[PHP-DB] for xml auto from MS Sql Server

2003-02-10 Thread Daniel Cher
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