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

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

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