note 25288 added to function.ocicolumnname
| From: | php-general at lists dot php dot net | Date: | Wed, 18 Sep 2002 09:53:49 +0000 |
| Subject: | note 25288 added to function.ocicolumnname | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-36882@lists.php.net to get a copy of this message | ||
As an former MySQL user, I used to use the keyword DESC in a query to get the fieldnames. DESC works
in SQL*Plus but not in standard Oracle SQL which is what is used in the OCI.
My worry was that trying to get column names with a SELECT statement would cause problems if the
table was empty and no results were returned. I tried it though and it is *NOT* a problem. Whether
rows are returned or not from your query, you can get the column names using OCIColumnName.
Just thought I'd point that out in case anyone else was about to spend a few minutes puzzling
over that.
--
http://www.php.net/manual/en/function.ocicolumnname.php
http://master.php.net/manage/user-notes.php?action=edit+25288
http://master.php.net/manage/user-notes.php?action=delete+25288
http://master.php.net/manage/user-notes.php?action=reject+25288