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 (Language.code = 'ref.outcontrol') AND (Country.isVisible = '1') AND (' at line 15SELECT `countryLanguageId` FROM `CountryLanguage` INNER JOIN `Country` AS `Country` ON `CountryLanguage`.`countryId` = `Country`.`countryId` INNER JOIN `Language` AS `Language` ON `CountryLanguage`.`languageId` = `Language`.`languageId` WHERE (Country.code = ?) AND (Language.code = 'ref.outcontrol') AND (Country.isVisible = '1') AND (Language.isVisible = '1')
/home/norisk/domains/securitymarkt.nl/public_html/System/Data/Driver/MySql.php (69)
0050: */
0051: public function query($statement)
0052: {
0053:
0054: // Query, or a statement object?
0055: if (is_string($statement)) {
0056: $sql = $statement;
0057: } else {
0058: $sql = $statement->__toString();
0059: }
0060:
0061: // Log query
0062: $this->getApplication()->getLog()->log(__CLASS__, $sql, __FILE__, __LINE__);
0063:
0064: // Get results
0065: $result = mysql_query($sql, $this->getDataConnection());
0066:
0067: // If a MYSQL error occured throw an exception
0068: if (mysql_error()) {
0069: throw new Exception(mysql_error() . $sql);
0070: }
0071:
0072: // Set results
0073: $this->setResult($result);
0074: }
0075:
0076: /**
0077: * Returns the row collection
0078: *
0079: * @return System_Data_RowCollection
0080: */
0081: public function getRowCollection()
0082: {
0083: /* @var $rowCollection System_Data_RowCollection */
0084: $rowCollection = System::instance('System.Data.RowCollection');
0085: while ($row = mysql_fetch_assoc($this->getResult())) {
0086: $rowCollection->add(System::instance('System.Data.Row', $row));
0087: }
0088:
0089: return $rowCollection;
#0 /home/norisk/domains/securitymarkt.nl/public_html/System/Data/Connection.php(139): System_Data_Driver_MySql->query(Object(System_Data_Statement_Select))
#1 /home/norisk/domains/securitymarkt.nl/public_html/System/Globalization.php(189): System_Data_Connection->query(Object(System_Data_Statement_Select))
#2 /home/norisk/domains/securitymarkt.nl/public_html/System/Web/UI/Tree/Item.php(134): System_Globalization->getCountryLanguageId()
#3 /home/norisk/domains/securitymarkt.nl/public_html/System/Web/Service/Frontend.php(177): System_Web_UI_Tree_Item->getChildCollection()
#4 /home/norisk/domains/securitymarkt.nl/public_html/System/Web/Service/Frontend.php(35): System_Web_Service_Frontend->getFromNavigation()
#5 /home/norisk/domains/securitymarkt.nl/public_html/System.php(107): System_Web_Service_Frontend->__construct()
#6 /home/norisk/domains/securitymarkt.nl/public_html/System/Application.php(333): System::instance('System.Web.Serv...')
#7 /home/norisk/domains/securitymarkt.nl/public_html/System/Application.php(313): System_Application->setService()
#8 /home/norisk/domains/securitymarkt.nl/public_html/System/Application.php(509): System_Application->getService()
#9 /home/norisk/domains/securitymarkt.nl/public_html/System/Application.php(462): System_Application->runService()
#10 /home/norisk/domains/securitymarkt.nl/public_html/index.php(26): System_Application->run()
#11 {main}