SQL Error: SQL Syntax Error

mrzizou

New Member
Error Message: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND domain = 'ard.qc' AND snapshot_id = 2010 AND locale = 'en_US'' at line 1SQL Query:\[code\]SELECT entity_id, content_idFROM collateral_cms_mapping WHERE entity_id IN ({$entity_ids}) AND domain = '{$this->getSite()->getInternalId()}' AND snapshot_id = {$this->getSnapshotDao()->getCurrentSnapshot()} AND locale = '{$locale}'\[/code\]Here is the actual SQL after value replace and string concatenation:\[code\] SELECT entity_id, content_id FROM collateral_cms_mapping WHERE entity_id IN () AND domain = 'ard.qc' AND snapshot_id = 2009 AND locale = 'en_US'\[/code\]Any Suggestions ?
 
Back
Top