Re: odbc_tables()

Thanks very much Frank, how about dtproperties ? I never created it but it still comes up .. do you know what it's for ? But thanks, seems like you know what you're talking about ! :) About the odbc_tables function, I have played with it for ages and i've read your post TWO DAYS ago and I still can't get it to work. Great post but maybe you could provide an example. As I said before I can odbc_result_all it but I can't actually extract individual values. Here is a link to the bug at bugs.php.net http://bugs.php.net/bugs.php?id=5755 Thanks again ! -- Matt

From: "Frank M. Kromann" <fmk@swwwing.com> Reply-To: "Frank M. Kromann" <fmk@swwwing.com> To: Matt <icq2000site@hotmail.com> CC: <php-general@lists.php.net> Subject: Re: [PHP] odbc_tables() Date: Wed, 15 Nov 2000 21:47:33 -0600 Hi, I have no problems with the functio, but you need to understant the parameters ! Read my comments in the manual. http://www.php.net/manual/function.odbc-tables.php If you want to do the same with a SQL statement (On MS SQL Server) you sould look at sysobjects. select name from sysopjects where type='U' returns the name of all user tables. - Frank I'm sure that many of you have encountered a problem with odbc_tables. After calling this command it is possible to perform a odbc_result_all on it and the entire result is printed nicely however it is far more difficult to store this information into a variable. It's actually a bug, fetch_into_row and fetch_result both do not work. Has anyone found a work around to this ? Btw, does anyone know an SQL statement that will perform a "show tables" function or another way of querying an MSSQL database to retrieve the desired information ? Thanks very much ! -- Matt _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net

_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.