[PHP-DB] Oracle and upper case field name

2004-01-27 Thread William Cheung
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 dont 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

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

2004-01-27 Thread Paul Miller
] 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

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

2004-01-27 Thread 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

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

2004-01-27 Thread 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 ??

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

2004-01-27 Thread 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