RE: [PHP-DB] Oracle and upper case field name
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 mailto:[EMAIL PROTECTED] 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
Re: [PHP-DB] Oracle and upper case field name
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
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
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