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