See the notes about case sensitivity here:
http://www.oracle.com/technology/tech/php/htdocs/php_troubleshooting_faq.html
Also, see the user comments here:
http://php.net/oci8
When fetching associative arrays, use uppercase string indices. It
appears the PHP OCI Library is less lenient with the field names
returned by Oracle.
e.g.
echo $row['field1']; // This won't return anything.
as opposed to:
echo $row['FIELD1'];
Cheers,
Gavin
[EMAIL PROTECTED] wrote:
Hi,
we are using zend frame work for development. Our application support three
databases MYSQL,MSSQL and ORACLE. With Oracle we are facing one problem it
is returning selected column names of the table in uppercase while we have
declared column names in lowercase during creation of table and because of
that we are not able to get the values from the recordset. here i am giving
you some code to clear the problem.
$rightrow = $db->fetchRow("select rep_right from e11contact_rep where
user_name='$user_id' ");
$repright = $rightrow["rep_right"];
but its returning "REP_RIGHT" as key value
Regards,
Dharmendra
Value one
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
--
Cheers,
Gavin
Which ZF List?
=================
Everything, except the topics below: [email protected]
Authorization, Authentication, ACL, Access Control, Session Management
[EMAIL PROTECTED]
Tests, Caching, Configuration, Environment, Logging
[EMAIL PROTECTED]
All things related to databases
[EMAIL PROTECTED]
Documentation, Translations, Wiki Manual / Tutorials
[EMAIL PROTECTED]
Internationalization & Localization, Dates, Calendar, Currency, Measure
[EMAIL PROTECTED]
Mail, MIME, PDF, Search, data formats (JSON, ...)
[EMAIL PROTECTED]
MVC, Controller, Router, Views, Zend_Request*
[EMAIL PROTECTED]
Community Servers/Services (shell account, PEAR channel, Jabber)
[EMAIL PROTECTED]
Web Services & Servers (HTTP, SOAP, Feeds, XMLRPC, REST)
[EMAIL PROTECTED]
How to subscribe: http://framework.zend.com/wiki/x/GgE
