ZF-9964: SQLSTATE: camel case is used for column names in database, exception occurs when such column names are used in where clause
I am coming across problem with Zend Framework, version 1.9
Message: SQLSTATE: Undefined column: 7 ERROR: column "shortname" does not exist LINE 1: SELECT "publisher".* FROM "publisher" WHERE (shortName = 'fs... ^
Perspective: I am using postgreSQL PDO and for column names camel notation is used.
Code View: $select = $this->getDbTable()->select(); $select->from('publisher'); $select->where("shortName = ?", $shortName); $select->order('id DESC'); $resultSet = $this->getDbTable()->fetchAll($select);
When I use lower case for column names, this exception doesn't occur. At this point it is very hard to change case for all columns of database. Any way around for this? Your response will be much appreciated!