[fw-general] Pls help with unwanted quotes in db-queries

2013-04-19 Thread GJ Bogaerts
Hello all, I'm having some trouble removing quotes from certain parts of my db-queries. For instance, this is part of a select()-statement: $select-join(array('m' = 'media'), m.foreignKey = p.id and m.belongsTo='product', array('mediaType', 'media' = $paths), $select::JOIN_LEFT); The on-part of

Re: [fw-general] Pls help with unwanted quotes in db-queries

2013-04-19 Thread Ralph Schindler
$select-join(array('m' = 'media'), m.foreignKey = p.id and m.belongsTo='product', array('mediaType', 'media' = $paths), $select::JOIN_LEFT); The on-part of this join produces: `m`.`foreignKey` = `p`.`id` and `m`.`belongsTo` = `'product'` - the backticks around product are actually invalid in