RE: [PHP-DB] Oracle and upper case field name

[Paul Miller]

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:[EMAIL PROTECTED] 
Sent: Tuesday, January 27, 2004 2:27 PM
To: [EMAIL PROTECTED]
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   B.Sc, MCSE, MCDBA

Databyte Corp.   

 


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

Re: [PHP-DB] Oracle and upper case field name

[Daniel Clark]

I might try having a common PHP function that converts all field names to
lower case, and call that function with every field name.

Or call each field by column number, $row[1]  .


> 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?




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Oracle and upper case field name

[John W. Holmes]

From: "Daniel Clark" <[EMAIL PROTECTED]>


> I might try having a common PHP function that converts all field names to
> lower case, and call that function with every field name.
> 
> Or call each field by column number, $row[1]  .

Like http://us2.php.net/manual/en/function.array-change-key-case.php ??

> > 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?

---John Holmes...

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Oracle and upper case field name

[Daniel Clark]

Yeah, Looks good to me :-)

> Like http://us2.php.net/manual/en/function.array-change-key-case.php ??
>
>> > 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?
>
> ---John Holmes...

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php