note 25288 added to function.ocicolumnname

From: 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

« previous php.notes (#36882) next »