Re: Re: MSSQL DataObject - support for listing tables in mssql.php

Am Fri, 10 Jan 2003 22:43:30 +0800 schrieb Alan Knowles <alan@akbkhome.com>: > Actually, The original comment was based around the old way I used to > gather table data : being describe tables..... > > now it uses pear's $db->tableInfo(); > which is in DB/mssql.php > > which appears to just raise an error.. > I've passed this on to sterling (cc'ing pear-dev)- as he's listed as the > author for that file... > To see if he thinks the code below is valid to go into mssql.php to > allow it to support table listing.. On which OS did you try this? If you´re on Linux and have enabled MSSQL support using --with-sybase, the tableInfo() method won´t work as the needed functions are not supported by the Sybase driver. AFAIK, as of PHP 4.3.0 you should be able to use --with-mssql on Linux so the full set of functions provided by this extension should be available - I haven´t tried it yet, though. If you´re on Windows, tableInfo() for MSSQL will work just fine even with older PHP versions. Regards, Markus -- *21st Media* | Consulting, Konzeption, Produktion für die Bereiche: Markus Wolff | Internet, Intranet, eCommerce, Content Management, Hamburg,Germany | Softwareentwicklung, 3D-Animation, Videostreaming http://21st.de | Tel. [+49](0)40/6887949-0, Fax: [+49](0)40/6887949-1