How to force adodb php library to use lowercase field names
        Posted  
        
            by spam
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by spam
        
        
        
        Published on 2009-06-23T21:34:57Z
        Indexed on 
            2010/04/17
            22:03 UTC
        
        
        Read the original article
        Hit count: 293
        
I'm trying to use adodb for db access in my webapp. However my hosting provider has mysql case sensitive, and I have all my fields in lowercase. But when I call getInsertSQL function, I got them in uppercase.
Is there a way to force adodb to use lowercase?
I tried with
define('ADODB_ASSOC_CASE', 0);
$ADODB_ASSOC_CASE = 0;
But it seems to be ignored as the constant is suppose to be used only with oracle, MSSQL and other DBMS
$conn = &ADONewConnection($this->DbType);
$conn = PConnect($dbServer,$dbUser, $dbPassword,$database);
$tableName = "sample";
$insertSQL = $conn->GetInsertSQL($tableName,$objDB);
And I got the SQL statement with the column names in uppercase.
© Stack Overflow or respective owner