RE: [PHP-DB] Oracle and upper case field name
| From: | Paul Miller | Date: | Tue, 27 Jan 2004 20:24:17 +0000 |
| Subject: | RE: [PHP-DB] Oracle and upper case field name | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32660@lists.php.net to get a copy of this message | ||
the way I do it is with http://www.ytztech.com product
SQL_AL.PHP which
has a switch that will say all values are upper or lower. You can also
create a simple wrapper function that will do the lower conversion.
- Paul
-----Original Message-----
From: William Cheung [mailto:william@databyte.com]
Sent: Tuesday, January 27, 2004 2:27 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Oracle and upper case field name
Hi,
When Oracle returns the result set, the field names are all in upper
case. However, I have an application that needs to work on both MSSQL
and Oracle. I don't want to keep 2 copies. One has upper case field
names and the other lower case. How could I make PHP or ADODB to work
with lower case field names even the result set is upper case?
William Cheung <mailto:william@databyte.com> B.Sc,
MCSE, MCDBA
Databyte Corp. <http://www.databyte.com/>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.567 / Virus Database: 358 - Release Date: 1/24/2004